eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 83: g_tax_unit_id pay_assignment_actions.tax_unit_id%type;

79: g_package constant varchar2(60) := 'pay_au_rec_det_paysum_mode.'; -- Global to store package name for tracing.
80:
81: g_end_date date;
82: g_start_date date;
83: g_tax_unit_id pay_assignment_actions.tax_unit_id%type;
84:
85: g_balance_type_tab g_bal_type_tab; /* TO Store the Allowances Balance Type IDs */
86: g_fbt_threshold ff_globals_f.global_value%TYPE ; /* Bug 5708255 */
87:

Line 438: ,c_legal_employer pay_assignment_actions.tax_unit_id%type

434: ,c_start_person per_all_people_f.person_id%type
435: ,c_end_person per_all_people_f.person_id%type
436: ,c_employee_type per_all_people_f.current_employee_flag%type
437: ,c_business_group_id hr_all_organization_units.organization_id%type
438: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
439: ,c_payroll_id varchar2
440: ,c_fin_year_start date
441: ,c_fin_year_end date
442: ,c_lst_fbt_yr_start date

Line 477: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)

473: and iipaf.effective_start_date <= c_fin_year_end
474: AND iipaf.payroll_id IS NOT NULL) /*Bug 4688800*/
475: and paa.payroll_id like c_payroll_id
476: and paa.assignment_id like c_assignment_id
477: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
478: INDEX(rpac pay_assignment_actions_n1)
479: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
480: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
481: FROM per_assignments_f paaf

Line 478: INDEX(rpac pay_assignment_actions_n1)

474: AND iipaf.payroll_id IS NOT NULL) /*Bug 4688800*/
475: and paa.payroll_id like c_payroll_id
476: and paa.assignment_id like c_assignment_id
477: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
478: INDEX(rpac pay_assignment_actions_n1)
479: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
480: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
481: FROM per_assignments_f paaf
482: ,pay_payroll_actions rppa

Line 483: ,pay_assignment_actions rpac

479: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
480: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
481: FROM per_assignments_f paaf
482: ,pay_payroll_actions rppa
483: ,pay_assignment_actions rpac
484: where (rppa.effective_date between c_fin_year_start and c_fin_year_end /*Bug3048962 */
485: or ( pps.actual_termination_date between c_lst_fbt_yr_start and c_fbt_year_end /*Bug3263659 */
486: and rppa.effective_date between c_fbt_year_start and c_fbt_year_end
487: and pay_balance_pkg.get_value(c_fbt_defined_balance_id, rpac.assignment_action_id

Line 512: ,c_legal_employer pay_assignment_actions.tax_unit_id%type

508: ,c_start_person per_all_people_f.person_id%type
509: ,c_end_person per_all_people_f.person_id%type
510: ,c_employee_type per_all_people_f.current_employee_flag%type
511: ,c_business_group_id hr_all_organization_units.organization_id%type
512: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
513: ,c_payroll_id varchar2
514: ,c_fin_year_start date
515: ,c_fin_year_end date
516: ,c_lst_fbt_yr_start date

Line 551: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)

547: and iipaf.effective_start_date <= c_fin_year_end
548: AND iipaf.payroll_id IS NOT NULL) /*Bug 4688800*/
549: and paa.payroll_id like c_payroll_id
550: and paa.assignment_id = c_assignment_id
551: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
552: INDEX(rpac pay_assignment_actions_n1)
553: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
554: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
555: FROM per_assignments_f paaf

Line 552: INDEX(rpac pay_assignment_actions_n1)

548: AND iipaf.payroll_id IS NOT NULL) /*Bug 4688800*/
549: and paa.payroll_id like c_payroll_id
550: and paa.assignment_id = c_assignment_id
551: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
552: INDEX(rpac pay_assignment_actions_n1)
553: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
554: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
555: FROM per_assignments_f paaf
556: ,pay_payroll_actions rppa

Line 557: ,pay_assignment_actions rpac

553: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
554: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
555: FROM per_assignments_f paaf
556: ,pay_payroll_actions rppa
557: ,pay_assignment_actions rpac
558: where (rppa.effective_date between c_fin_year_start and c_fin_year_end /*Bug3048962 */
559: or ( pps.actual_termination_date between c_lst_fbt_yr_start and c_fbt_year_end /*Bug3263659 */
560: and rppa.effective_date between c_fbt_year_start and c_fbt_year_end
561: and pay_balance_pkg.get_value(c_fbt_defined_balance_id, rpac.assignment_action_id

Line 589: ,c_legal_employer pay_assignment_actions.tax_unit_id%type

585: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
586: ,c_chunk NUMBER
587: ,c_employee_type per_all_people_f.current_employee_flag%type
588: ,c_business_group_id hr_all_organization_units.organization_id%type
589: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
590: ,c_payroll_id varchar2
591: ,c_fin_year_start date
592: ,c_fin_year_end date
593: ,c_lst_fbt_yr_start date

Line 631: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)

627: AND iipaf.effective_start_date <= c_fin_year_end
628: AND iipaf.payroll_id IS NOT NULL) /*Bug 4688800*/
629: AND paa.payroll_id like c_payroll_id
630: AND paa.assignment_id like c_assignment_id
631: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
632: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
633: */''
634: FROM per_assignments_f paaf
635: ,pay_payroll_actions rppa

Line 636: ,pay_assignment_actions rpac

632: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
633: */''
634: FROM per_assignments_f paaf
635: ,pay_payroll_actions rppa
636: ,pay_assignment_actions rpac
637: WHERE (rppa.effective_date between c_fin_year_start AND c_fin_year_end /*Bug3048962 */
638: or ( pps.actual_termination_date between c_lst_fbt_yr_start AND c_fbt_year_end /*Bug3263659 */
639: AND rppa.effective_date between c_fbt_year_start AND c_fbt_year_end
640: AND pay_balance_pkg.get_value(c_fbt_defined_balance_id, rpac.assignment_action_id

Line 666: select pay_assignment_actions_s.nextval

662: and pbd.legislation_code = pbt.legislation_code
663: and pbd.legislation_code = pdb.legislation_code;
664:
665: cursor csr_next_action_id is
666: select pay_assignment_actions_s.nextval
667: from dual;
668:
669: /* Bug 5708255 */
670: -------------------------------------------

Line 683: l_next_assignment_action_id pay_assignment_actions.assignment_action_id%type;

679: AND c_year_end BETWEEN effective_start_date
680: AND effective_end_date ;
681:
682:
683: l_next_assignment_action_id pay_assignment_actions.assignment_action_id%type;
684: l_procedure varchar2(200) ;
685: i number;
686:
687: l_lst_yr_start date;

Line 889: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

885: -- fetches appropriate Balance values using BBR.
886: --------------------------------------------------------------------+
887:
888: procedure archive_code
889: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
890: ,p_effective_date in pay_payroll_actions.effective_date%type
891: )
892: is
893:

Line 927: pay_assignment_actions paa1

923: per_pay_bases ppb,
924: per_pay_proposals pro,
925: per_assignment_status_types past,
926: hr_organization_units hou,
927: pay_assignment_actions paa1
928: ,hr_soft_coding_keyflex hsc
929: ,hr_organization_units hou1
930: -- ,pay_payrolls_f papf /*Bug 4688800*/
931: where pap.person_id = paa.person_id

Line 1002: pay_assignment_actions paa

998: pps.actual_termination_date
999: from per_people_f pap,
1000: per_assignments_f paf,
1001: per_periods_of_service pps,
1002: pay_assignment_actions paa
1003: where pap.person_id = paf.person_id
1004: and paf.assignment_id = paa.assignment_id
1005: and pps.person_id = pap.person_id
1006: and pps.period_of_service_id = paf.period_of_service_id

Line 1028: from pay_assignment_actions paa

1024: ,c_tax_unit_id varchar2)
1025: is
1026: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
1027: ,max(paa.action_sequence) action_sequence
1028: from pay_assignment_actions paa
1029: , pay_payroll_actions ppa
1030: , per_assignments_f paf
1031: where paa.assignment_id = paf.assignment_id
1032: and paf.assignment_id = c_assignment_id

Line 1050: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE)

1046: --------------------------------------------------------------------+
1047:
1048: cursor c_payment_summary_details(c_assignment_id number,
1049: c_fin_date date,
1050: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE)
1051: is
1052: select hr.meaning fin_year
1053: from per_assignment_extra_info pae,
1054: hr_lookups hr

Line 1397: procedure get_fbt_balance(p_assignment_id in pay_assignment_actions.assignment_id%type

1393: -- and Medicare Levy
1394: --------------------------------------------------------------------+
1395:
1396:
1397: procedure get_fbt_balance(p_assignment_id in pay_assignment_actions.assignment_id%type
1398: ,p_start_date in date
1399: ,p_end_date in date
1400: ,p_action_sequence out nocopy number)
1401: is

Line 1403: c_assignment_id pay_assignment_actions.assignment_id%TYPE,

1399: ,p_end_date in date
1400: ,p_action_sequence out nocopy number)
1401: is
1402: cursor c_max_assignment_action_id(
1403: c_assignment_id pay_assignment_actions.assignment_id%TYPE,
1404: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE,
1405: c_start_date date,
1406: c_end_date date)
1407: IS

Line 1404: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE,

1400: ,p_action_sequence out nocopy number)
1401: is
1402: cursor c_max_assignment_action_id(
1403: c_assignment_id pay_assignment_actions.assignment_id%TYPE,
1404: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE,
1405: c_start_date date,
1406: c_end_date date)
1407: IS
1408: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id

Line 1410: from pay_assignment_actions paa

1406: c_end_date date)
1407: IS
1408: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
1409: ,max(paa.action_sequence) action_sequence
1410: from pay_assignment_actions paa
1411: , pay_payroll_actions ppa
1412: , per_assignments_f paf
1413: where paa.assignment_id = paf.assignment_id
1414: and paf.assignment_id = c_assignment_id

Line 1435: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;

1431: AND effective_end_date ;
1432:
1433: r_global c_get_global%ROWTYPE;
1434: l_bal_value number;
1435: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;
1436: l_max_action_sequence pay_assignment_actions.action_sequence%type;
1437: l_med_levy number;
1438: l_fbt_rate number;
1439:

Line 1436: l_max_action_sequence pay_assignment_actions.action_sequence%type;

1432:
1433: r_global c_get_global%ROWTYPE;
1434: l_bal_value number;
1435: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;
1436: l_max_action_sequence pay_assignment_actions.action_sequence%type;
1437: l_med_levy number;
1438: l_fbt_rate number;
1439:
1440: l_procedure varchar2(240);

Line 1509: procedure archive_element_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE

1505: -- In case of Allowance elements,builds a PL/SQL table with
1506: -- the Allowance Balance_Type_ID's
1507: --------------------------------------------------------------------+
1508:
1509: procedure archive_element_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
1510: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
1511: ,p_effective_date in date
1512: ,p_pre01jul1983_ratio in number
1513: ,p_post30jun1983_ratio in number

Line 1510: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE

1506: -- the Allowance Balance_Type_ID's
1507: --------------------------------------------------------------------+
1508:
1509: procedure archive_element_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
1510: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
1511: ,p_effective_date in date
1512: ,p_pre01jul1983_ratio in number
1513: ,p_post30jun1983_ratio in number
1514: ,p_allowance_exists out nocopy number)

Line 1530: (c_assignment_id pay_assignment_actions.assignment_id%TYPE,

1526: /*Bug 5603254 - Removed tables piv2 and prrv2 and their joins from cursor , added a call to function pay_au_rec_det_archive.get_element_payment_hours to get the value for hours and rate */
1527: /*Bug 5846278 - Added Lump Sum E Payments in Not exists Clause */
1528:
1529: cursor c_ps_element_details
1530: (c_assignment_id pay_assignment_actions.assignment_id%TYPE,
1531: c_business_group_id hr_all_organization_units.organization_id%TYPE,
1532: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE,
1533: c_start_date date,
1534: c_end_date date)

Line 1532: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE,

1528:
1529: cursor c_ps_element_details
1530: (c_assignment_id pay_assignment_actions.assignment_id%TYPE,
1531: c_business_group_id hr_all_organization_units.organization_id%TYPE,
1532: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE,
1533: c_start_date date,
1534: c_end_date date)
1535: is
1536: select element_name,label classification_name,sum(amount) payment,sum(hours) hours,rate,balance_type_id

Line 1561: ,pay_assignment_actions paa

1557: ,nvl(pet.element_information2,0) balance_type_id
1558: from pay_element_types_f pet
1559: ,pay_input_values_f piv1
1560: ,pay_element_classifications pec
1561: ,pay_assignment_actions paa
1562: ,pay_payroll_actions ppa
1563: ,per_assignments_f paaf
1564: ,pay_run_results prr
1565: ,pay_run_result_values prrv1

Line 1844: procedure Adjust_lumpsum_E_payments(p_assignment_id in pay_assignment_actions.assignment_id%type)

1840: /* Bug 4201894 - Adjusted Amount will be cumulatively stored in
1841: g_adjusted_lump_sum_e_pay and displayed in Taxable Earnings
1842: element section */
1843: --------------------------------------------------------------------+
1844: procedure Adjust_lumpsum_E_payments(p_assignment_id in pay_assignment_actions.assignment_id%type)
1845: is
1846: CURSOR c_single_lumpsum_E_payment(c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
1847: c_tax_unit_id pay_assignment_actions.tax_unit_id%type)
1848: IS

Line 1846: CURSOR c_single_lumpsum_E_payment(c_assignment_action_id pay_assignment_actions.assignment_action_id%type,

1842: element section */
1843: --------------------------------------------------------------------+
1844: procedure Adjust_lumpsum_E_payments(p_assignment_id in pay_assignment_actions.assignment_id%type)
1845: is
1846: CURSOR c_single_lumpsum_E_payment(c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
1847: c_tax_unit_id pay_assignment_actions.tax_unit_id%type)
1848: IS
1849: select sum(pay_balance_pkg.get_value(pdb.defined_balance_id,
1850: c_assignment_action_id,

Line 1847: c_tax_unit_id pay_assignment_actions.tax_unit_id%type)

1843: --------------------------------------------------------------------+
1844: procedure Adjust_lumpsum_E_payments(p_assignment_id in pay_assignment_actions.assignment_id%type)
1845: is
1846: CURSOR c_single_lumpsum_E_payment(c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
1847: c_tax_unit_id pay_assignment_actions.tax_unit_id%type)
1848: IS
1849: select sum(pay_balance_pkg.get_value(pdb.defined_balance_id,
1850: c_assignment_action_id,
1851: c_tax_unit_id,

Line 1865: CURSOR c_get_pay_effective_date(c_assignment_id pay_assignment_actions.assignment_id%type

1861:
1862: /*Bug 4363057 - Cursor has been modified so that the Lump Sum E Payments given to previous legal employers
1863: can be taken into account while calculating payment summary gross.*/
1864:
1865: CURSOR c_get_pay_effective_date(c_assignment_id pay_assignment_actions.assignment_id%type
1866: ,c_year_start in DATE
1867: ,c_year_end in DATE
1868: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%type )
1869: IS

Line 1868: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%type )

1864:
1865: CURSOR c_get_pay_effective_date(c_assignment_id pay_assignment_actions.assignment_id%type
1866: ,c_year_start in DATE
1867: ,c_year_end in DATE
1868: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%type )
1869: IS
1870: select max(paa.assignment_action_id) assignment_action_id
1871: from per_assignments_f paf,
1872: pay_payroll_Actions ppa,

Line 1873: pay_assignment_Actions paa,

1869: IS
1870: select max(paa.assignment_action_id) assignment_action_id
1871: from per_assignments_f paf,
1872: pay_payroll_Actions ppa,
1873: pay_assignment_Actions paa,
1874: per_time_periods ptp
1875: where ppa.payroll_Action_id = paa.payroll_Action_id
1876: and paa.assignment_id = c_assignment_id
1877: and paf.assignment_id = paa.assignment_id

Line 1893: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

1889: v_lump_sum_E_ytd number;
1890: v_lump_sum_E_ptd number;
1891: v_adj_lump_sum_E_ptd number; /* Bug 4201894 */
1892:
1893: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
1894:
1895:
1896: begin
1897:

Line 1945: procedure get_allowance_balances(p_assignment_id in pay_assignment_actions.assignment_id%type

1941: -- Retro Payments.
1942: --------------------------------------------------------------------+
1943:
1944:
1945: procedure get_allowance_balances(p_assignment_id in pay_assignment_actions.assignment_id%type
1946: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type)
1947: is
1948:
1949: cursor c_allowance_balance(c_balance_type_id pay_balance_types.balance_type_id%type)

Line 1946: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type)

1942: --------------------------------------------------------------------+
1943:
1944:
1945: procedure get_allowance_balances(p_assignment_id in pay_assignment_actions.assignment_id%type
1946: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type)
1947: is
1948:
1949: cursor c_allowance_balance(c_balance_type_id pay_balance_types.balance_type_id%type)
1950: is

Line 2060: procedure archive_balance_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE

2056: -- Normal Balances - AU_BALANCE_RECON_DETAILS_YTD
2057: -- Payment Summary Balances - AU_PS_BALANCE_RECON_DETAILS
2058: --------------------------------------------------------------------+
2059:
2060: procedure archive_balance_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
2061: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
2062: ,p_effective_date in date
2063: ,p_pre01jul1983_ratio in number
2064: ,p_post30jun1983_ratio in number

Line 2061: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE

2057: -- Payment Summary Balances - AU_PS_BALANCE_RECON_DETAILS
2058: --------------------------------------------------------------------+
2059:
2060: procedure archive_balance_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
2061: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
2062: ,p_effective_date in date
2063: ,p_pre01jul1983_ratio in number
2064: ,p_post30jun1983_ratio in number
2065: ,p_run_action_sequence in pay_assignment_actions.action_sequence%type)

Line 2065: ,p_run_action_sequence in pay_assignment_actions.action_sequence%type)

2061: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
2062: ,p_effective_date in date
2063: ,p_pre01jul1983_ratio in number
2064: ,p_post30jun1983_ratio in number
2065: ,p_run_action_sequence in pay_assignment_actions.action_sequence%type)
2066: is
2067: l_procedure varchar2(80);
2068:
2069: l_YTD_TAXABLE_EARNINGS number;

Line 2459: (c_assignment_id pay_assignment_actions.assignment_id%type

2455:
2456: /* Bug 7138494 - Changed rom Date Earned to Effective date for better
2457: performance */
2458: cursor get_allowance_balance_types
2459: (c_assignment_id pay_assignment_actions.assignment_id%type
2460: ,c_start_date date
2461: ,c_end_date date
2462: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%type)
2463: IS

Line 2462: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%type)

2458: cursor get_allowance_balance_types
2459: (c_assignment_id pay_assignment_actions.assignment_id%type
2460: ,c_start_date date
2461: ,c_end_date date
2462: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%type)
2463: IS
2464: SELECT DISTINCT pet.element_information2 balance_type_id
2465: FROM pay_element_types_f pet
2466: ,per_all_assignments_f paf

Line 2468: ,pay_assignment_actions paa

2464: SELECT DISTINCT pet.element_information2 balance_type_id
2465: FROM pay_element_types_f pet
2466: ,per_all_assignments_f paf
2467: ,pay_payroll_actions ppa
2468: ,pay_assignment_actions paa
2469: ,pay_run_results prr
2470: WHERE ppa.effective_date BETWEEN c_start_date AND c_end_date
2471: AND ppa.action_type in ('R','Q','B','V','I')
2472: AND ppa.payroll_id = paf.payroll_id