[Home] [Help]
370: )
371:
372: FROM per_addresses pad,
373: per_assignments_f paf,
374: pay_assignment_actions paa,
375: pay_payroll_actions ppa
376:
377: WHERE pad.primary_flag = 'Y'
378: AND pad.person_id = paf.person_id
442: to_char(p_regular_aggregate) );
443:
444: SELECT paa.assignment_id
445: INTO l_assignment_id
446: FROM pay_assignment_actions paa
447: where paa.assignment_action_id = p_assignment_action_id;
448:
449:
450: /* commented for bug 7238809 .As fetching home jurisdiction using
471: SELECT /*+ RULE */ paa1.assignment_action_id,
472: ppa1.payroll_id
473: INTO l_bal_assact,
474: l_payroll_id
475: FROM pay_assignment_Actions paa1,
476: pay_payroll_actions ppa1
477: WHERE paa1.assignment_id = l_assignment_id
478: AND paa1.tax_unit_id = p_tax_unit_id
479: AND paa1.action_sequence =
479: AND paa1.action_sequence =
480: (SELECT max(paa_prev.action_sequence)
481: FROM per_time_periods ptp
482: , pay_payroll_actions ppa
483: , pay_assignment_actions paa
484: , per_time_periods ptp_prev
485: , pay_payroll_actions ppa_prev
486: , pay_assignment_actions paa_prev
487: WHERE paa.assignment_action_id = p_assignment_action_id
482: , pay_payroll_actions ppa
483: , pay_assignment_actions paa
484: , per_time_periods ptp_prev
485: , pay_payroll_actions ppa_prev
486: , pay_assignment_actions paa_prev
487: WHERE paa.assignment_action_id = p_assignment_action_id
488: AND ppa.payroll_action_id = paa.payroll_action_id
489: -- AND ptp.time_period_id = ppa.time_period_id
490: AND ppa.effective_date between ptp.start_date /*Bug:3909937*/
1390: and piv2.effective_end_date
1391: and piv2.name = 'Percentage';
1392:
1393: Cursor tagged_earnings_Cursor is
1394: select /*+ INDEX (paa pay_assignment_actions_n51) */ distinct
1395: peev.element_entry_id,
1396: peev.screen_entry_value
1397: from pay_element_classifications pec
1398: ,pay_element_types_f pet
1425: -- Get flag to determine assignment has only IT time.
1426: CURSOR csr_use_it_flag (p_assignment_action_id IN NUMBER) IS
1427: SELECT NVL(fed.fed_information1,'N'),paa.assignment_id
1428: FROM pay_us_emp_fed_tax_rules_f fed,
1429: pay_assignment_actions paa,
1430: pay_payroll_actions ppa
1431: WHERE paa.assignment_id = fed.assignment_id
1432: AND paa.assignment_action_id = p_assignment_action_id
1433: AND paa.payroll_action_id = ppa.payroll_action_id
1460: l_time_period_id,
1461: l_payroll_id,
1462: l_business_group_id,
1463: l_tax_unit_id
1464: FROM pay_assignment_actions paa,
1465: pay_payroll_actions ppa
1466: WHERE paa.assignment_action_id = p_assignment_action_id
1467: AND ppa.payroll_action_id = paa.payroll_action_id;
1468:
2554: CURSOR csr_period_flag (p_assignment_action_id IN NUMBER) IS
2555: SELECT NVL(prl_information12 ,'P') --Defaulted to Previous
2556: ,NVL(prl_information13 ,'YTD') --defaulted to Tax Year
2557: FROM pay_payrolls_f payroll,
2558: pay_assignment_actions paa,
2559: pay_payroll_actions ppa
2560: WHERE ppa.payroll_id = payroll.payroll_id
2561: AND paa.payroll_action_id = ppa.payroll_action_id
2562: AND paa.assignment_action_id = p_assignment_action_id
2739: p_end_date IN DATE,
2740: p_assignment_id IN NUMBER,
2741: p_date_earned IN DATE)
2742: IS
2743: SELECT /*+ INDEX (paa pay_assignment_actions_n51) */ DISTINCT
2744: peev.screen_entry_value Jurisdiction,
2745: 0 Hours
2746: FROM pay_element_classifications pec
2747: ,pay_element_types_f pet
6515: FROM pay_run_result_values TARGET
6516: ,pay_balance_types BAL
6517: ,pay_balance_feeds_f FEED
6518: ,pay_run_results RR
6519: ,pay_assignment_actions ASSACT
6520: ,pay_assignment_actions BAL_ASSACT
6521: ,pay_payroll_actions PACT
6522: ,pay_payroll_actions BACT
6523: ,per_all_assignments_f ASS
6516: ,pay_balance_types BAL
6517: ,pay_balance_feeds_f FEED
6518: ,pay_run_results RR
6519: ,pay_assignment_actions ASSACT
6520: ,pay_assignment_actions BAL_ASSACT
6521: ,pay_payroll_actions PACT
6522: ,pay_payroll_actions BACT
6523: ,per_all_assignments_f ASS
6524: WHERE BAL_ASSACT.assignment_action_id = p_asgmnt_action_id