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 662: ,p_time_period_id in per_time_periods.time_period_id%type

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
665: ) is
666:

Line 669: (p_time_period_id per_time_periods.time_period_id%type

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

Line 685: (p_time_period_id per_time_periods.time_period_id%type

681: and action_type IN ('R','Q','V');
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

Line 701: (p_time_period_id per_time_periods.time_period_id%type

697: and action_type IN ('R','Q','V');
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

Line 716: (p_time_period_id per_time_periods.time_period_id%type

712: and action_type IN ('R','Q','V');
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

Line 730: (p_time_period_id per_time_periods.time_period_id%type

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

Line 744: (p_time_period_id per_time_periods.time_period_id%type

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

Line 758: (p_time_period_id per_time_periods.time_period_id%type

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

Line 1478: ,p_time_period_id in per_time_periods.time_period_id%type

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
1479: ,p_period_end_date in per_time_periods.end_date%type /* Bug No : 2491444 */
1480: ,p_regular_payment_date in per_time_periods.regular_payment_date%type /* Bug# 5681819*/
1481: ) is
1482:

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

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
1479: ,p_period_end_date in per_time_periods.end_date%type /* Bug No : 2491444 */
1480: ,p_regular_payment_date in per_time_periods.regular_payment_date%type /* Bug# 5681819*/
1481: ) is
1482:
1483: l_action_info_id pay_action_information.action_information_id%type;

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

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
1479: ,p_period_end_date in per_time_periods.end_date%type /* Bug No : 2491444 */
1480: ,p_regular_payment_date in per_time_periods.regular_payment_date%type /* Bug# 5681819*/
1481: ) is
1482:
1483: l_action_info_id pay_action_information.action_information_id%type;
1484: l_ovn pay_action_information.object_version_number%type;

Line 1536: per_time_periods ptp,

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

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

1619: , p_curr_eff_date => p_run_effective_date -- payroll run effective_date
1620: , p_date_earned => p_run_date_earned -- payroll date_earned
1621: , p_curr_pymt_eff_date => p_period_end_date -- latest run period end date, needed for core choose payslip
1622: , p_tax_unit_id => l_tax_unit_id -- GRE contained in tax_unit_id for assignment_action
1623: , p_time_period_id => p_time_period_id -- time_period_id from per_time_periods /* Bug No : 2491444 */
1624: , p_ppp_source_action_id => NULL
1625: );
1626:
1627: hr_utility.set_location('AU Finished get_personal_information',15);

Line 1962: per_time_periods ptp

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
1963: where paa_arch_mst.assignment_action_id = p_master_aa_id
1964: and paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id
1965: and paa_arch_chd.payroll_action_id = paa_arch_mst.payroll_action_id
1966: and paa_arch_chd.assignment_id = paa_arch_mst.assignment_id

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

2017: ,p_pre_assignment_action_id => payslip_rec.pre_assignment_action_id -- prepayment run assignment action
2018: ,p_pre_effective_date => payslip_rec.pre_effective_date -- prepayment run effective date
2019: ,p_run_effective_date => payslip_rec.run_effective_date -- payroll run effective_date
2020: ,p_run_date_earned => payslip_rec.run_date_earned -- payroll run date_earned
2021: ,p_time_period_id => payslip_rec.time_period_id -- time_period_id from per_time_periods
2022: ,p_period_end_date => payslip_rec.period_end_date -- end date from per_time_periods
2023: ,p_regular_payment_date => payslip_rec.regular_payment_date -- Regular payment date from per_time_periods /* 5681819 */
2024: );
2025:

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

2018: ,p_pre_effective_date => payslip_rec.pre_effective_date -- prepayment run effective date
2019: ,p_run_effective_date => payslip_rec.run_effective_date -- payroll run effective_date
2020: ,p_run_date_earned => payslip_rec.run_date_earned -- payroll run date_earned
2021: ,p_time_period_id => payslip_rec.time_period_id -- time_period_id from per_time_periods
2022: ,p_period_end_date => payslip_rec.period_end_date -- end date from per_time_periods
2023: ,p_regular_payment_date => payslip_rec.regular_payment_date -- Regular payment date from per_time_periods /* 5681819 */
2024: );
2025:
2026: hr_utility.set_location(l_procedure,50);

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

2019: ,p_run_effective_date => payslip_rec.run_effective_date -- payroll run effective_date
2020: ,p_run_date_earned => payslip_rec.run_date_earned -- payroll run date_earned
2021: ,p_time_period_id => payslip_rec.time_period_id -- time_period_id from per_time_periods
2022: ,p_period_end_date => payslip_rec.period_end_date -- end date from per_time_periods
2023: ,p_regular_payment_date => payslip_rec.regular_payment_date -- Regular payment date from per_time_periods /* 5681819 */
2024: );
2025:
2026: hr_utility.set_location(l_procedure,50);
2027: --