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 PER_TIME_PERIODS

Line 652: ,p_time_period_id in per_time_periods.time_period_id%type

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
655: ) is
656:

Line 659: (p_time_period_id per_time_periods.time_period_id%type

655: ) is
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

Line 674: (p_time_period_id per_time_periods.time_period_id%type

670: and assignment_id = p_assignment_id;
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

Line 689: (p_time_period_id per_time_periods.time_period_id%type

685: and assignment_id = p_assignment_id;
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

Line 703: (p_time_period_id per_time_periods.time_period_id%type

699: and assignment_id = p_assignment_id;
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

Line 717: (p_time_period_id per_time_periods.time_period_id%type

713: and assignment_id = p_assignment_id;
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

Line 1313: ,p_time_period_id in per_time_periods.time_period_id%type

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
1314: ,p_period_end_date in per_time_periods.end_date%type /* Bug No : 2491444 */
1315: ,p_regular_payment_date in per_time_periods.regular_payment_date%type /* Bug# 5681819*/
1316: ) is
1317:

Line 1314: ,p_period_end_date in per_time_periods.end_date%type /* Bug No : 2491444 */

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
1314: ,p_period_end_date in per_time_periods.end_date%type /* Bug No : 2491444 */
1315: ,p_regular_payment_date in per_time_periods.regular_payment_date%type /* Bug# 5681819*/
1316: ) is
1317:
1318: l_action_info_id pay_action_information.action_information_id%type;

Line 1315: ,p_regular_payment_date in per_time_periods.regular_payment_date%type /* Bug# 5681819*/

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
1314: ,p_period_end_date in per_time_periods.end_date%type /* Bug No : 2491444 */
1315: ,p_regular_payment_date in per_time_periods.regular_payment_date%type /* Bug# 5681819*/
1316: ) is
1317:
1318: l_action_info_id pay_action_information.action_information_id%type;
1319: l_ovn pay_action_information.object_version_number%type;

Line 1371: per_time_periods ptp,

1367: p_pre_effective_date pay_payroll_actions.effective_date%type)
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

Line 1458: , p_time_period_id => p_time_period_id -- time_period_id from per_time_periods /* Bug No : 2491444 */

1454: , p_curr_eff_date => p_run_effective_date -- payroll run effective_date
1455: , p_date_earned => p_run_date_earned -- payroll date_earned
1456: , p_curr_pymt_eff_date => p_period_end_date -- latest run period end date, needed for core choose payslip
1457: , p_tax_unit_id => l_tax_unit_id -- GRE contained in tax_unit_id for assignment_action
1458: , p_time_period_id => p_time_period_id -- time_period_id from per_time_periods /* Bug No : 2491444 */
1459: , p_ppp_source_action_id => NULL
1460: );
1461:
1462: hr_utility.set_location('AU Finished get_personal_information',15);

Line 1675: per_time_periods ptp

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
1676: where paa_arch_mst.assignment_action_id = p_master_aa_id
1677: and paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id
1678: and paa_arch_chd.payroll_action_id = paa_arch_mst.payroll_action_id
1679: and paa_arch_chd.assignment_id = paa_arch_mst.assignment_id

Line 1727: ,p_time_period_id => payslip_rec.time_period_id -- time_period_id from per_time_periods

1723: ,p_pre_assignment_action_id => payslip_rec.pre_assignment_action_id -- prepayment run assignment action
1724: ,p_pre_effective_date => payslip_rec.pre_effective_date -- prepayment run effective date
1725: ,p_run_effective_date => payslip_rec.run_effective_date -- payroll run effective_date
1726: ,p_run_date_earned => payslip_rec.run_date_earned -- payroll run date_earned
1727: ,p_time_period_id => payslip_rec.time_period_id -- time_period_id from per_time_periods
1728: ,p_period_end_date => payslip_rec.period_end_date -- end date from per_time_periods
1729: ,p_regular_payment_date => payslip_rec.regular_payment_date -- Regular payment date from per_time_periods /* 5681819 */
1730: );
1731:

Line 1728: ,p_period_end_date => payslip_rec.period_end_date -- end date from per_time_periods

1724: ,p_pre_effective_date => payslip_rec.pre_effective_date -- prepayment run effective date
1725: ,p_run_effective_date => payslip_rec.run_effective_date -- payroll run effective_date
1726: ,p_run_date_earned => payslip_rec.run_date_earned -- payroll run date_earned
1727: ,p_time_period_id => payslip_rec.time_period_id -- time_period_id from per_time_periods
1728: ,p_period_end_date => payslip_rec.period_end_date -- end date from per_time_periods
1729: ,p_regular_payment_date => payslip_rec.regular_payment_date -- Regular payment date from per_time_periods /* 5681819 */
1730: );
1731:
1732: hr_utility.set_location(l_procedure,60);

Line 1729: ,p_regular_payment_date => payslip_rec.regular_payment_date -- Regular payment date from per_time_periods /* 5681819 */

1725: ,p_run_effective_date => payslip_rec.run_effective_date -- payroll run effective_date
1726: ,p_run_date_earned => payslip_rec.run_date_earned -- payroll run date_earned
1727: ,p_time_period_id => payslip_rec.time_period_id -- time_period_id from per_time_periods
1728: ,p_period_end_date => payslip_rec.period_end_date -- end date from per_time_periods
1729: ,p_regular_payment_date => payslip_rec.regular_payment_date -- Regular payment date from per_time_periods /* 5681819 */
1730: );
1731:
1732: hr_utility.set_location(l_procedure,60);
1733: --