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 193: (p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type

189: --
190: --------------------------------------------------------------------
191:
192: procedure archive_stat_elements
193: (p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type
194: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
195: ,p_assignment_id in pay_assignment_actions.assignment_id%type
196: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
197: ) is

Line 195: ,p_assignment_id in pay_assignment_actions.assignment_id%type

191:
192: procedure archive_stat_elements
193: (p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type
194: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
195: ,p_assignment_id in pay_assignment_actions.assignment_id%type
196: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
197: ) is
198:
199: cursor csr_std_elements

Line 196: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type

192: procedure archive_stat_elements
193: (p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type
194: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
195: ,p_assignment_id in pay_assignment_actions.assignment_id%type
196: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
197: ) is
198:
199: cursor csr_std_elements
200: (p_assignment_action_id number

Line 286: (p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type

282: Number formatting done under enhancement 3604094 handled for the new column also.
283: */
284:
285: procedure archive_balances
286: (p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
287: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
288: ,p_narrative in varchar2
289: ,p_ytd in number
290: ,p_tp in number --Bug 3891564

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

326: --
327: --------------------------------------------------------------------
328:
329: procedure archive_stat_balances
330: (p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type /*4363057*/
331: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
332: ,p_assignment_id in pay_assignment_actions.assignment_id%type
333: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
334: ,p_calculation_date in pay_payroll_actions.effective_date%type

Line 332: ,p_assignment_id in pay_assignment_actions.assignment_id%type

328:
329: procedure archive_stat_balances
330: (p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type /*4363057*/
331: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
332: ,p_assignment_id in pay_assignment_actions.assignment_id%type
333: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
334: ,p_calculation_date in pay_payroll_actions.effective_date%type
335: ) is
336: l_gross_this_pay number;

Line 333: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type

329: procedure archive_stat_balances
330: (p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type /*4363057*/
331: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
332: ,p_assignment_id in pay_assignment_actions.assignment_id%type
333: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
334: ,p_calculation_date in pay_payroll_actions.effective_date%type
335: ) is
336: l_gross_this_pay number;
337: l_other_deductions_this_pay number;

Line 526: (p_assignment_id in pay_assignment_actions.assignment_id%type

522: --
523: ---------------------------------------------------------------------------
524:
525: procedure archive_accruals
526: (p_assignment_id in pay_assignment_actions.assignment_id%type
527: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
528: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type
529: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
530: ,p_calculation_date in date

Line 528: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type

524:
525: procedure archive_accruals
526: (p_assignment_id in pay_assignment_actions.assignment_id%type
527: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
528: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type
529: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
530: ,p_calculation_date in date
531: ) is
532: --

Line 529: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type

525: procedure archive_accruals
526: (p_assignment_id in pay_assignment_actions.assignment_id%type
527: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
528: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type
529: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
530: ,p_calculation_date in date
531: ) is
532: --
533: l_assignment_id per_all_assignments_f.assignment_id%type;

Line 543: (p_assignment_action_id pay_assignment_actions.assignment_action_id%type)

539: -- Cursor to retrieve the Annual Leave accrual plan
540: -- information.
541: --
542: cursor csr_annual_leave_plan
543: (p_assignment_action_id pay_assignment_actions.assignment_action_id%type)
544: is
545: select ap.accrual_plan_id
546: , ap.accrual_plan_name
547: , hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',ap.accrual_category) accrual_category

Line 555: , pay_assignment_actions aa

551: from pay_accrual_plans ap
552: , pay_element_types_f et
553: , pay_element_links_f el
554: , pay_element_entries_f ee
555: , pay_assignment_actions aa
556: , pay_payroll_actions pa
557: where et.element_type_id = ap.accrual_plan_element_type_id -- select the accrual plan elements
558: and el.element_type_id = et.element_type_id -- select accrual plan element entries
559: and aa.assignment_id = ee.assignment_id -- select element entries for this assignment

Line 650: (p_assignment_id in pay_assignment_actions.assignment_id%type

646: l_exists and tab_row declared to ensure duplicate rows fetched from different views are not inserted again
647: into pay_action_information */
648:
649: procedure archive_absences
650: (p_assignment_id in pay_assignment_actions.assignment_id%type
651: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
652: ,p_time_period_id in per_time_periods.time_period_id%type
653: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
654: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type

Line 653: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type

649: procedure archive_absences
650: (p_assignment_id in pay_assignment_actions.assignment_id%type
651: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
652: ,p_time_period_id in per_time_periods.time_period_id%type
653: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
654: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type
655: ) is
656:
657:

Line 654: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type

650: (p_assignment_id in pay_assignment_actions.assignment_id%type
651: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
652: ,p_time_period_id in per_time_periods.time_period_id%type
653: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
654: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type
655: ) is
656:
657:
658: cursor csr_leave_taken1

Line 660: ,p_assignment_id pay_assignment_actions.assignment_id%type

656:
657:
658: cursor csr_leave_taken1
659: (p_time_period_id per_time_periods.time_period_id%type
660: ,p_assignment_id pay_assignment_actions.assignment_id%type
661: ) is
662: select row_id
663: , element_reporting_name
664: , start_date

Line 675: ,p_assignment_id pay_assignment_actions.assignment_id%type

671:
672:
673: cursor csr_leave_taken2
674: (p_time_period_id per_time_periods.time_period_id%type
675: ,p_assignment_id pay_assignment_actions.assignment_id%type
676: ) is
677: select row_id,
678: element_reporting_name
679: , start_date

Line 690: ,p_assignment_id pay_assignment_actions.assignment_id%type

686:
687:
688: cursor csr_leave_taken3
689: (p_time_period_id per_time_periods.time_period_id%type
690: ,p_assignment_id pay_assignment_actions.assignment_id%type
691: ) is
692: select row_id,element_reporting_name
693: , start_date
694: , end_date

Line 704: ,p_assignment_id pay_assignment_actions.assignment_id%type

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

Line 718: ,p_assignment_id pay_assignment_actions.assignment_id%type

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

Line 1128: from pay_assignment_actions paa,

1124: ppp.pre_payment_id,
1125: popm.org_payment_method_id,
1126: popm.org_payment_method_name,
1127: pppm.personal_payment_method_id
1128: from pay_assignment_actions paa,
1129: pay_pre_payments ppp,
1130: pay_org_payment_methods_f popm ,
1131: pay_personal_payment_methods_f pppm,
1132: pay_external_accounts pea

Line 1148: pay_assignment_actions paa_run,

1144: and cp_ppp_source_action_id is null
1145: and exists (
1146: select ''
1147: from pay_run_types_f prt,
1148: pay_assignment_actions paa_run,
1149: pay_payroll_actions ppa_run
1150: where paa_run.assignment_action_id
1151: = ppp.source_action_id
1152: and paa_run.payroll_action_id

Line 1306: (p_assignment_id in pay_assignment_actions.assignment_id%type

1302: -- are archived into the structure 'AU EMPLOYEE DETAILS'
1303: ---------------------------------------------------------------------------------------
1304:
1305: procedure archive_employee_details
1306: (p_assignment_id in pay_assignment_actions.assignment_id%type
1307: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for archive run
1308: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for payroll run
1309: ,p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for prepayment run
1310: ,p_pre_effective_date in pay_payroll_actions.effective_date%type -- effective date of prepayment run

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

1303: ---------------------------------------------------------------------------------------
1304:
1305: procedure archive_employee_details
1306: (p_assignment_id in pay_assignment_actions.assignment_id%type
1307: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for archive run
1308: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for payroll run
1309: ,p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for prepayment run
1310: ,p_pre_effective_date in pay_payroll_actions.effective_date%type -- effective date of prepayment run
1311: ,p_run_effective_date in pay_payroll_actions.effective_date%type -- effective date of payroll run

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

1304:
1305: procedure archive_employee_details
1306: (p_assignment_id in pay_assignment_actions.assignment_id%type
1307: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for archive run
1308: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for payroll run
1309: ,p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for prepayment run
1310: ,p_pre_effective_date in pay_payroll_actions.effective_date%type -- effective date of prepayment run
1311: ,p_run_effective_date in pay_payroll_actions.effective_date%type -- effective date of payroll run
1312: ,p_run_date_earned in pay_payroll_actions.date_earned%type

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

1305: procedure archive_employee_details
1306: (p_assignment_id in pay_assignment_actions.assignment_id%type
1307: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for archive run
1308: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for payroll run
1309: ,p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for prepayment run
1310: ,p_pre_effective_date in pay_payroll_actions.effective_date%type -- effective date of prepayment run
1311: ,p_run_effective_date in pay_payroll_actions.effective_date%type -- effective date of payroll run
1312: ,p_run_date_earned in pay_payroll_actions.date_earned%type
1313: ,p_time_period_id in per_time_periods.time_period_id%type

Line 1323: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

1319: l_ovn pay_action_information.object_version_number%type;
1320: l_date_earned pay_payroll_actions.date_earned%type;
1321: l_procedure varchar2(80) ;
1322: l_abn number;
1323: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1324:
1325: cursor csr_tax_unit
1326: (p_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
1327: select tax_unit_id

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

1322: l_abn number;
1323: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1324:
1325: cursor csr_tax_unit
1326: (p_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
1327: select tax_unit_id
1328: from pay_assignment_actions
1329: where assignment_action_id = p_assignment_action_id;
1330:

Line 1328: from pay_assignment_actions

1324:
1325: cursor csr_tax_unit
1326: (p_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
1327: select tax_unit_id
1328: from pay_assignment_actions
1329: where assignment_action_id = p_assignment_action_id;
1330:
1331: --
1332: -- Get the Employer ABN which is stored

Line 1337: (p_assignment_id pay_assignment_actions.assignment_id%type

1333: -- in the organization EIT strucutre AU_LEGAL_EMPLOYER
1334: --
1335: /*Bug2920725 Corrected base tables to support security model*/
1336: cursor csr_abn
1337: (p_assignment_id pay_assignment_actions.assignment_id%type
1338: ,p_effective_date pay_payroll_actions.effective_date%type
1339: ) is
1340: select org.org_information12 abn
1341: from per_assignments_f paaf

Line 1351: (p_prepay_action_id pay_assignment_actions.assignment_action_id%type,

1347: and paaf.assignment_id = p_assignment_id
1348: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
1349:
1350: CURSOR csr_child_action
1351: (p_prepay_action_id pay_assignment_actions.assignment_action_id%type,
1352: p_source_action_id pay_assignment_actions.assignment_action_id%type) IS
1353: SELECT paa.assignment_action_id
1354: FROM pay_assignment_actions paa,
1355: pay_action_interlocks pai,

Line 1352: p_source_action_id pay_assignment_actions.assignment_action_id%type) IS

1348: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
1349:
1350: CURSOR csr_child_action
1351: (p_prepay_action_id pay_assignment_actions.assignment_action_id%type,
1352: p_source_action_id pay_assignment_actions.assignment_action_id%type) IS
1353: SELECT paa.assignment_action_id
1354: FROM pay_assignment_actions paa,
1355: pay_action_interlocks pai,
1356: pay_run_types_f prt

Line 1354: FROM pay_assignment_actions paa,

1350: CURSOR csr_child_action
1351: (p_prepay_action_id pay_assignment_actions.assignment_action_id%type,
1352: p_source_action_id pay_assignment_actions.assignment_action_id%type) IS
1353: SELECT paa.assignment_action_id
1354: FROM pay_assignment_actions paa,
1355: pay_action_interlocks pai,
1356: pay_run_types_f prt
1357: WHERE pai.locking_action_id = p_prepay_action_id
1358: and paa.assignment_action_id = pai.locked_action_id

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

1361:
1362: /* Bug 5504354 - Added cursor to get pay_advice_date */
1363: /* Bug 6032985 - Added ptp.default_dd_date in place of pay_advice_date ,in case where
1364: ptp.default_dd_date is null use effective date of Pre Payment */
1365: cursor csr_pay_advice_date(p_run_assignment_action_id pay_assignment_actions.assignment_action_id%type ,
1366: p_run_date_earned pay_payroll_actions.date_earned%type,
1367: p_pre_effective_date pay_payroll_actions.effective_date%type)
1368: is
1369: select nvl(ptp.default_dd_date,p_pre_effective_date)

Line 1372: pay_assignment_actions paa

1368: is
1369: select nvl(ptp.default_dd_date,p_pre_effective_date)
1370: from pay_payroll_actions ppa,
1371: per_time_periods ptp,
1372: pay_assignment_actions paa
1373: where p_run_date_earned between ptp.start_date and ptp.end_date
1374: and paa.assignment_action_id=p_run_assignment_action_id
1375: and paa.payroll_action_id=ppa.payroll_action_id
1376: and ppa.payroll_id=ptp.payroll_id;

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

1375: and paa.payroll_action_id=ppa.payroll_action_id
1376: and ppa.payroll_id=ptp.payroll_id;
1377:
1378: /* Bug 5504354 c_get_bus_id */
1379: cursor c_get_bus_id ( p_assignment_id pay_assignment_actions.assignment_id%type
1380: ,p_effective_date date ) is
1381: select distinct business_group_id
1382: from per_all_assignments_f
1383: where assignment_id=p_assignment_id

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

1385:
1386:
1387: /* Bug 5504354 - Cursor c_grade_step added to get the grade step of an assignment */
1388:
1389: cursor c_grade_step(p_assignment_id pay_assignment_actions.assignment_id%type
1390: ,p_effective_date pay_payroll_actions.effective_date%type,
1391: p_business_group_id per_all_assignments_f.business_group_id%type
1392: ) is
1393: select count(*)

Line 1417: l_child_action_id pay_assignment_actions.assignment_action_id%type;

1413: l_step varchar2(10); /* Bug 5504354 */
1414:
1415: l_pay_advice_date date ; /* Bug 5504354 */
1416:
1417: l_child_action_id pay_assignment_actions.assignment_action_id%type;
1418:
1419: begin
1420: l_procedure := g_package||'archive_employee_details';
1421: hr_utility.set_location('Entering '|| l_procedure,1);

Line 1652: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

1648: --
1649: --
1650: ----------------------------
1651: procedure archive_code
1652: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
1653: ,p_effective_date in pay_payroll_actions.effective_date%type
1654: ) is
1655:
1656: cursor get_payslip_aa(p_master_aa_id number)

Line 1667: from pay_assignment_actions paa_arch_chd,

1663: ppa_run.effective_date run_effective_date,
1664: ppa_run.date_earned run_date_earned,
1665: ptp.regular_payment_date, /* 5681819 */ptp.end_date period_end_date,
1666: ptp.time_period_id
1667: from pay_assignment_actions paa_arch_chd,
1668: pay_assignment_actions paa_arch_mst,
1669: pay_assignment_actions paa_pre,
1670: pay_action_interlocks pai_pre,
1671: pay_assignment_actions paa_run,

Line 1668: pay_assignment_actions paa_arch_mst,

1664: ppa_run.date_earned run_date_earned,
1665: ptp.regular_payment_date, /* 5681819 */ptp.end_date period_end_date,
1666: ptp.time_period_id
1667: from pay_assignment_actions paa_arch_chd,
1668: pay_assignment_actions paa_arch_mst,
1669: pay_assignment_actions paa_pre,
1670: pay_action_interlocks pai_pre,
1671: pay_assignment_actions paa_run,
1672: pay_action_interlocks pai_run,

Line 1669: pay_assignment_actions paa_pre,

1665: ptp.regular_payment_date, /* 5681819 */ptp.end_date period_end_date,
1666: ptp.time_period_id
1667: from pay_assignment_actions paa_arch_chd,
1668: pay_assignment_actions paa_arch_mst,
1669: pay_assignment_actions paa_pre,
1670: pay_action_interlocks pai_pre,
1671: pay_assignment_actions paa_run,
1672: pay_action_interlocks pai_run,
1673: pay_payroll_actions ppa_pre,

Line 1671: pay_assignment_actions paa_run,

1667: from pay_assignment_actions paa_arch_chd,
1668: pay_assignment_actions paa_arch_mst,
1669: pay_assignment_actions paa_pre,
1670: pay_action_interlocks pai_pre,
1671: pay_assignment_actions paa_run,
1672: pay_action_interlocks pai_run,
1673: pay_payroll_actions ppa_pre,
1674: pay_payroll_actions ppa_run,
1675: per_time_periods ptp

Line 1693: from pay_assignment_actions paa_run2,

1689: and ppa_run.date_earned between ptp.start_date
1690: and ptp.end_date
1691: -- Get the highest in sequence for this payslip
1692: and paa_run.action_sequence = (select max(paa_run2.action_sequence)
1693: from pay_assignment_actions paa_run2,
1694: pay_action_interlocks pai_run2
1695: where pai_run2.locking_action_id =
1696: paa_arch_chd.assignment_action_id
1697: and pai_run2.locked_action_id =