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_PAYSLIP_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 42: punemhta 06-Feb-2004 115.11 3245909 Added a new condition to cursor csr_prepay_assignment_actions of

38: statment for fetching the cursor 'csr_annual_leave_plan'.
39: apunekar 29-May-2003 115.9 2920725 Corrected base tables to support security model
40: vgsriniv 17-Nov-2003 115.10 3260854 Done validation for divide by zero error in
41: procedure archive_stat_elements
42: punemhta 06-Feb-2004 115.11 3245909 Added a new condition to cursor csr_prepay_assignment_actions of
43: archive_code to support Run Types.
44: punemhta 25-Feb-2004 115.12 3466097 Added a new condition for archiving Elements
45: punemhta 25-Mar-2004 115.13 3245909 called get_net_pay function multiple times to arcvhie child payment methods
46: punemhta 26-Mar-2004 115.14 3245909 ROlled back changs made in ver. 115.13

Line 203: (p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type

199: --
200: --------------------------------------------------------------------
201:
202: procedure archive_stat_elements
203: (p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type
204: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
205: ,p_assignment_id in pay_assignment_actions.assignment_id%type
206: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
207: ) is

Line 205: ,p_assignment_id in pay_assignment_actions.assignment_id%type

201:
202: procedure archive_stat_elements
203: (p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type
204: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
205: ,p_assignment_id in pay_assignment_actions.assignment_id%type
206: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
207: ) is
208:
209: cursor csr_std_elements

Line 206: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type

202: procedure archive_stat_elements
203: (p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type
204: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
205: ,p_assignment_id in pay_assignment_actions.assignment_id%type
206: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
207: ) is
208:
209: cursor csr_std_elements
210: (p_assignment_action_id number

Line 296: (p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type

292: Number formatting done under enhancement 3604094 handled for the new column also.
293: */
294:
295: procedure archive_balances
296: (p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
297: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
298: ,p_narrative in varchar2
299: ,p_ytd in number
300: ,p_tp in number --Bug 3891564

Line 340: (p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type /4363057/

336: --
337: --------------------------------------------------------------------
338:
339: procedure archive_stat_balances
340: (p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type /*4363057*/
341: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
342: ,p_assignment_id in pay_assignment_actions.assignment_id%type
343: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
344: ,p_calculation_date in pay_payroll_actions.effective_date%type

Line 342: ,p_assignment_id in pay_assignment_actions.assignment_id%type

338:
339: procedure archive_stat_balances
340: (p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type /*4363057*/
341: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
342: ,p_assignment_id in pay_assignment_actions.assignment_id%type
343: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
344: ,p_calculation_date in pay_payroll_actions.effective_date%type
345: ) is
346: l_gross_this_pay number;

Line 343: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type

339: procedure archive_stat_balances
340: (p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type /*4363057*/
341: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
342: ,p_assignment_id in pay_assignment_actions.assignment_id%type
343: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
344: ,p_calculation_date in pay_payroll_actions.effective_date%type
345: ) is
346: l_gross_this_pay number;
347: l_other_deductions_this_pay number;

Line 536: (p_assignment_id in pay_assignment_actions.assignment_id%type

532: --
533: ---------------------------------------------------------------------------
534:
535: procedure archive_accruals
536: (p_assignment_id in pay_assignment_actions.assignment_id%type
537: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
538: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type
539: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
540: ,p_calculation_date in date

Line 538: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type

534:
535: procedure archive_accruals
536: (p_assignment_id in pay_assignment_actions.assignment_id%type
537: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
538: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type
539: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
540: ,p_calculation_date in date
541: ) is
542: --

Line 539: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type

535: procedure archive_accruals
536: (p_assignment_id in pay_assignment_actions.assignment_id%type
537: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
538: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type
539: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
540: ,p_calculation_date in date
541: ) is
542: --
543: l_assignment_id per_all_assignments_f.assignment_id%type;

Line 553: (p_assignment_action_id pay_assignment_actions.assignment_action_id%type)

549: -- Cursor to retrieve the Annual Leave accrual plan
550: -- information.
551: --
552: cursor csr_annual_leave_plan
553: (p_assignment_action_id pay_assignment_actions.assignment_action_id%type)
554: is
555: select ap.accrual_plan_id
556: , ap.accrual_plan_name
557: , hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',ap.accrual_category) accrual_category

Line 565: , pay_assignment_actions aa

561: from pay_accrual_plans ap
562: , pay_element_types_f et
563: , pay_element_links_f el
564: , pay_element_entries_f ee
565: , pay_assignment_actions aa
566: , pay_payroll_actions pa
567: where et.element_type_id = ap.accrual_plan_element_type_id -- select the accrual plan elements
568: and el.element_type_id = et.element_type_id -- select accrual plan element entries
569: and aa.assignment_id = ee.assignment_id -- select element entries for this assignment

Line 660: (p_assignment_id in pay_assignment_actions.assignment_id%type

656: l_exists and tab_row declared to ensure duplicate rows fetched from different views are not inserted again
657: into pay_action_information */
658:
659: procedure archive_absences
660: (p_assignment_id in pay_assignment_actions.assignment_id%type
661: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
662: ,p_time_period_id in per_time_periods.time_period_id%type
663: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
664: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type

Line 663: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type

659: procedure archive_absences
660: (p_assignment_id in pay_assignment_actions.assignment_id%type
661: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
662: ,p_time_period_id in per_time_periods.time_period_id%type
663: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
664: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type
665: ) is
666:
667:

Line 664: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type

660: (p_assignment_id in pay_assignment_actions.assignment_id%type
661: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
662: ,p_time_period_id in per_time_periods.time_period_id%type
663: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
664: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type
665: ) is
666:
667:
668: cursor csr_leave_taken1

Line 670: ,p_assignment_id pay_assignment_actions.assignment_id%type

666:
667:
668: cursor csr_leave_taken1
669: (p_time_period_id per_time_periods.time_period_id%type
670: ,p_assignment_id pay_assignment_actions.assignment_id%type
671: ) is
672: select row_id
673: , element_reporting_name
674: , start_date

Line 686: ,p_assignment_id pay_assignment_actions.assignment_id%type

682:
683:
684: cursor csr_leave_taken2
685: (p_time_period_id per_time_periods.time_period_id%type
686: ,p_assignment_id pay_assignment_actions.assignment_id%type
687: ) is
688: select row_id,
689: element_reporting_name
690: , start_date

Line 702: ,p_assignment_id pay_assignment_actions.assignment_id%type

698:
699:
700: cursor csr_leave_taken3
701: (p_time_period_id per_time_periods.time_period_id%type
702: ,p_assignment_id pay_assignment_actions.assignment_id%type
703: ) is
704: select row_id,element_reporting_name
705: , start_date
706: , end_date

Line 717: ,p_assignment_id pay_assignment_actions.assignment_id%type

713:
714:
715: cursor csr_leave_taken4
716: (p_time_period_id per_time_periods.time_period_id%type
717: ,p_assignment_id pay_assignment_actions.assignment_id%type
718: ) is
719: select row_id,element_reporting_name
720: , start_date
721: , end_date

Line 731: ,p_assignment_id pay_assignment_actions.assignment_id%type

727:
728:
729: cursor csr_leave_taken5
730: (p_time_period_id per_time_periods.time_period_id%type
731: ,p_assignment_id pay_assignment_actions.assignment_id%type
732: ) is
733: select row_id,element_reporting_name
734: , start_date
735: , end_date

Line 745: ,p_assignment_id pay_assignment_actions.assignment_id%type

741: and action_type IN ('R','Q','V');
742:
743: cursor csr_leave_taken6
744: (p_time_period_id per_time_periods.time_period_id%type
745: ,p_assignment_id pay_assignment_actions.assignment_id%type
746: ) is
747: select row_id,element_reporting_name
748: , start_date
749: , end_date

Line 759: ,p_assignment_id pay_assignment_actions.assignment_id%type

755: and action_type IN ('R','Q','V');
756:
757: cursor csr_leave_taken7
758: (p_time_period_id per_time_periods.time_period_id%type
759: ,p_assignment_id pay_assignment_actions.assignment_id%type
760: ) is
761: select row_id,element_reporting_name
762: , start_date
763: , end_date

Line 1293: from pay_assignment_actions paa,

1289: ppp.pre_payment_id,
1290: popm.org_payment_method_id,
1291: popm.org_payment_method_name,
1292: pppm.personal_payment_method_id
1293: from pay_assignment_actions paa,
1294: pay_pre_payments ppp,
1295: pay_org_payment_methods_f popm ,
1296: pay_personal_payment_methods_f pppm,
1297: pay_external_accounts pea

Line 1313: pay_assignment_actions paa_run,

1309: and cp_ppp_source_action_id is null
1310: and exists (
1311: select ''
1312: from pay_run_types_f prt,
1313: pay_assignment_actions paa_run,
1314: pay_payroll_actions ppa_run
1315: where paa_run.assignment_action_id
1316: = ppp.source_action_id
1317: and paa_run.payroll_action_id

Line 1471: (p_assignment_id in pay_assignment_actions.assignment_id%type

1467: -- are archived into the structure 'AU EMPLOYEE DETAILS'
1468: ---------------------------------------------------------------------------------------
1469:
1470: procedure archive_employee_details
1471: (p_assignment_id in pay_assignment_actions.assignment_id%type
1472: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for archive run
1473: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for payroll run
1474: ,p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for prepayment run
1475: ,p_pre_effective_date in pay_payroll_actions.effective_date%type -- effective date of prepayment run

Line 1472: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for archive run

1468: ---------------------------------------------------------------------------------------
1469:
1470: procedure archive_employee_details
1471: (p_assignment_id in pay_assignment_actions.assignment_id%type
1472: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for archive run
1473: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for payroll run
1474: ,p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for prepayment run
1475: ,p_pre_effective_date in pay_payroll_actions.effective_date%type -- effective date of prepayment run
1476: ,p_run_effective_date in pay_payroll_actions.effective_date%type -- effective date of payroll run

Line 1473: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for payroll run

1469:
1470: procedure archive_employee_details
1471: (p_assignment_id in pay_assignment_actions.assignment_id%type
1472: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for archive run
1473: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for payroll run
1474: ,p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for prepayment run
1475: ,p_pre_effective_date in pay_payroll_actions.effective_date%type -- effective date of prepayment run
1476: ,p_run_effective_date in pay_payroll_actions.effective_date%type -- effective date of payroll run
1477: ,p_run_date_earned in pay_payroll_actions.date_earned%type

Line 1474: ,p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for prepayment run

1470: procedure archive_employee_details
1471: (p_assignment_id in pay_assignment_actions.assignment_id%type
1472: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for archive run
1473: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for payroll run
1474: ,p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for prepayment run
1475: ,p_pre_effective_date in pay_payroll_actions.effective_date%type -- effective date of prepayment run
1476: ,p_run_effective_date in pay_payroll_actions.effective_date%type -- effective date of payroll run
1477: ,p_run_date_earned in pay_payroll_actions.date_earned%type
1478: ,p_time_period_id in per_time_periods.time_period_id%type

Line 1488: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

1484: l_ovn pay_action_information.object_version_number%type;
1485: l_date_earned pay_payroll_actions.date_earned%type;
1486: l_procedure varchar2(80) ;
1487: l_abn number;
1488: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1489:
1490: cursor csr_tax_unit
1491: (p_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
1492: select tax_unit_id

Line 1491: (p_assignment_action_id pay_assignment_actions.assignment_action_id%type) is

1487: l_abn number;
1488: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1489:
1490: cursor csr_tax_unit
1491: (p_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
1492: select tax_unit_id
1493: from pay_assignment_actions
1494: where assignment_action_id = p_assignment_action_id;
1495:

Line 1493: from pay_assignment_actions

1489:
1490: cursor csr_tax_unit
1491: (p_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
1492: select tax_unit_id
1493: from pay_assignment_actions
1494: where assignment_action_id = p_assignment_action_id;
1495:
1496: --
1497: -- Get the Employer ABN which is stored

Line 1502: (p_assignment_id pay_assignment_actions.assignment_id%type

1498: -- in the organization EIT strucutre AU_LEGAL_EMPLOYER
1499: --
1500: /*Bug2920725 Corrected base tables to support security model*/
1501: cursor csr_abn
1502: (p_assignment_id pay_assignment_actions.assignment_id%type
1503: ,p_effective_date pay_payroll_actions.effective_date%type
1504: ) is
1505: select org.org_information12 abn
1506: from per_assignments_f paaf

Line 1516: (p_prepay_action_id pay_assignment_actions.assignment_action_id%type,

1512: and paaf.assignment_id = p_assignment_id
1513: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
1514:
1515: CURSOR csr_child_action
1516: (p_prepay_action_id pay_assignment_actions.assignment_action_id%type,
1517: p_source_action_id pay_assignment_actions.assignment_action_id%type) IS
1518: SELECT paa.assignment_action_id
1519: FROM pay_assignment_actions paa,
1520: pay_action_interlocks pai,

Line 1517: p_source_action_id pay_assignment_actions.assignment_action_id%type) IS

1513: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
1514:
1515: CURSOR csr_child_action
1516: (p_prepay_action_id pay_assignment_actions.assignment_action_id%type,
1517: p_source_action_id pay_assignment_actions.assignment_action_id%type) IS
1518: SELECT paa.assignment_action_id
1519: FROM pay_assignment_actions paa,
1520: pay_action_interlocks pai,
1521: pay_run_types_f prt

Line 1519: FROM pay_assignment_actions paa,

1515: CURSOR csr_child_action
1516: (p_prepay_action_id pay_assignment_actions.assignment_action_id%type,
1517: p_source_action_id pay_assignment_actions.assignment_action_id%type) IS
1518: SELECT paa.assignment_action_id
1519: FROM pay_assignment_actions paa,
1520: pay_action_interlocks pai,
1521: pay_run_types_f prt
1522: WHERE pai.locking_action_id = p_prepay_action_id
1523: and paa.assignment_action_id = pai.locked_action_id

Line 1530: cursor csr_pay_advice_date(p_run_assignment_action_id pay_assignment_actions.assignment_action_id%type ,

1526:
1527: /* Bug 5504354 - Added cursor to get pay_advice_date */
1528: /* Bug 6032985 - Added ptp.default_dd_date in place of pay_advice_date ,in case where
1529: ptp.default_dd_date is null use effective date of Pre Payment */
1530: cursor csr_pay_advice_date(p_run_assignment_action_id pay_assignment_actions.assignment_action_id%type ,
1531: p_run_date_earned pay_payroll_actions.date_earned%type,
1532: p_pre_effective_date pay_payroll_actions.effective_date%type)
1533: is
1534: select nvl(ptp.default_dd_date,p_pre_effective_date)

Line 1537: pay_assignment_actions paa

1533: is
1534: select nvl(ptp.default_dd_date,p_pre_effective_date)
1535: from pay_payroll_actions ppa,
1536: per_time_periods ptp,
1537: pay_assignment_actions paa
1538: where p_run_date_earned between ptp.start_date and ptp.end_date
1539: and paa.assignment_action_id=p_run_assignment_action_id
1540: and paa.payroll_action_id=ppa.payroll_action_id
1541: and ppa.payroll_id=ptp.payroll_id;

Line 1544: cursor c_get_bus_id ( p_assignment_id pay_assignment_actions.assignment_id%type

1540: and paa.payroll_action_id=ppa.payroll_action_id
1541: and ppa.payroll_id=ptp.payroll_id;
1542:
1543: /* Bug 5504354 c_get_bus_id */
1544: cursor c_get_bus_id ( p_assignment_id pay_assignment_actions.assignment_id%type
1545: ,p_effective_date date ) is
1546: select distinct business_group_id
1547: from per_all_assignments_f
1548: where assignment_id=p_assignment_id

Line 1554: cursor c_grade_step(p_assignment_id pay_assignment_actions.assignment_id%type

1550:
1551:
1552: /* Bug 5504354 - Cursor c_grade_step added to get the grade step of an assignment */
1553:
1554: cursor c_grade_step(p_assignment_id pay_assignment_actions.assignment_id%type
1555: ,p_effective_date pay_payroll_actions.effective_date%type,
1556: p_business_group_id per_all_assignments_f.business_group_id%type
1557: ) is
1558: select count(*)

Line 1582: l_child_action_id pay_assignment_actions.assignment_action_id%type;

1578: l_step varchar2(10); /* Bug 5504354 */
1579:
1580: l_pay_advice_date date ; /* Bug 5504354 */
1581:
1582: l_child_action_id pay_assignment_actions.assignment_action_id%type;
1583:
1584: begin
1585: l_procedure := g_package||'archive_employee_details';
1586: hr_utility.set_location('Entering '|| l_procedure,1);

Line 1872: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

1868: --
1869: ----------------------------
1870:
1871: procedure archive_quickpay_pa_info
1872: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
1873: ,p_effective_date in pay_payroll_actions.effective_date%type
1874: ) is
1875:
1876: cursor csr_get_payroll_action_id(

Line 1877: p_aa_id pay_assignment_actions.assignment_action_id%TYPE)

1873: ,p_effective_date in pay_payroll_actions.effective_date%type
1874: ) is
1875:
1876: cursor csr_get_payroll_action_id(
1877: p_aa_id pay_assignment_actions.assignment_action_id%TYPE)
1878: is
1879: select payroll_action_id
1880: from pay_assignment_actions paa
1881: where paa.assignment_action_id = p_aa_id;

Line 1880: from pay_assignment_actions paa

1876: cursor csr_get_payroll_action_id(
1877: p_aa_id pay_assignment_actions.assignment_action_id%TYPE)
1878: is
1879: select payroll_action_id
1880: from pay_assignment_actions paa
1881: where paa.assignment_action_id = p_aa_id;
1882:
1883: cursor csr_is_employer_addr_archived(
1884: p_payroll_action_id pay_action_information.action_context_id%TYPE

Line 1939: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

1935: --
1936: --
1937: ----------------------------
1938: procedure archive_code
1939: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
1940: ,p_effective_date in pay_payroll_actions.effective_date%type
1941: ) is
1942:
1943: cursor get_payslip_aa(p_master_aa_id number)

Line 1954: from pay_assignment_actions paa_arch_chd,

1950: ppa_run.effective_date run_effective_date,
1951: ppa_run.date_earned run_date_earned,
1952: ptp.regular_payment_date, /* 5681819 */ptp.end_date period_end_date,
1953: ptp.time_period_id
1954: from pay_assignment_actions paa_arch_chd,
1955: pay_assignment_actions paa_arch_mst,
1956: pay_assignment_actions paa_pre,
1957: pay_action_interlocks pai_pre,
1958: pay_assignment_actions paa_run,

Line 1955: pay_assignment_actions paa_arch_mst,

1951: ppa_run.date_earned run_date_earned,
1952: ptp.regular_payment_date, /* 5681819 */ptp.end_date period_end_date,
1953: ptp.time_period_id
1954: from pay_assignment_actions paa_arch_chd,
1955: pay_assignment_actions paa_arch_mst,
1956: pay_assignment_actions paa_pre,
1957: pay_action_interlocks pai_pre,
1958: pay_assignment_actions paa_run,
1959: pay_action_interlocks pai_run,

Line 1956: pay_assignment_actions paa_pre,

1952: ptp.regular_payment_date, /* 5681819 */ptp.end_date period_end_date,
1953: ptp.time_period_id
1954: from pay_assignment_actions paa_arch_chd,
1955: pay_assignment_actions paa_arch_mst,
1956: pay_assignment_actions paa_pre,
1957: pay_action_interlocks pai_pre,
1958: pay_assignment_actions paa_run,
1959: pay_action_interlocks pai_run,
1960: pay_payroll_actions ppa_pre,

Line 1958: pay_assignment_actions paa_run,

1954: from pay_assignment_actions paa_arch_chd,
1955: pay_assignment_actions paa_arch_mst,
1956: pay_assignment_actions paa_pre,
1957: pay_action_interlocks pai_pre,
1958: pay_assignment_actions paa_run,
1959: pay_action_interlocks pai_run,
1960: pay_payroll_actions ppa_pre,
1961: pay_payroll_actions ppa_run,
1962: per_time_periods ptp

Line 1980: from pay_assignment_actions paa_run2,

1976: and ppa_run.date_earned between ptp.start_date
1977: and ptp.end_date
1978: -- Get the highest in sequence for this payslip
1979: and paa_run.action_sequence = (select max(paa_run2.action_sequence)
1980: from pay_assignment_actions paa_run2,
1981: pay_action_interlocks pai_run2
1982: where pai_run2.locking_action_id =
1983: paa_arch_chd.assignment_action_id
1984: and pai_run2.locked_action_id =