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_FI_PAYLIST_ARCHIVE dependencies on PER_TIME_PERIODS

Line 253: ptp.regular_payment_date from pay_payroll_actions ppa,per_time_periods ptp,pay_all_payrolls_f papf

249: csr_v_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
250: )
251: IS
252: select papf.payroll_name,ptp.end_date , ptp.period_name ,
253: ptp.regular_payment_date from pay_payroll_actions ppa,per_time_periods ptp,pay_all_payrolls_f papf
254: where ptp.time_period_id=ppa.time_period_id
255: and ppa.PAYROLL_ID=papf.PAYROLL_ID
256: and ppa.payroll_action_id=csr_v_payroll_action_id;
257:

Line 601: l_end_date per_time_periods.end_date%TYPE;

597:
598: l_archive_payact_id NUMBER;
599: l_record_count NUMBER;
600: l_actid NUMBER;
601: l_end_date per_time_periods.end_date%TYPE;
602: l_pre_end_date per_time_periods.end_date%TYPE;
603: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
604: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
605: l_date_earned pay_payroll_actions.date_earned%TYPE;

Line 602: l_pre_end_date per_time_periods.end_date%TYPE;

598: l_archive_payact_id NUMBER;
599: l_record_count NUMBER;
600: l_actid NUMBER;
601: l_end_date per_time_periods.end_date%TYPE;
602: l_pre_end_date per_time_periods.end_date%TYPE;
603: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
604: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
605: l_date_earned pay_payroll_actions.date_earned%TYPE;
606: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;

Line 603: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;

599: l_record_count NUMBER;
600: l_actid NUMBER;
601: l_end_date per_time_periods.end_date%TYPE;
602: l_pre_end_date per_time_periods.end_date%TYPE;
603: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
604: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
605: l_date_earned pay_payroll_actions.date_earned%TYPE;
606: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
607: l_effective_date pay_payroll_actions.effective_date%TYPE;

Line 604: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;

600: l_actid NUMBER;
601: l_end_date per_time_periods.end_date%TYPE;
602: l_pre_end_date per_time_periods.end_date%TYPE;
603: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
604: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
605: l_date_earned pay_payroll_actions.date_earned%TYPE;
606: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
607: l_effective_date pay_payroll_actions.effective_date%TYPE;
608: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;

Line 613: l_time_period_id per_time_periods.time_period_id%TYPE;

609: l_run_payact_id NUMBER;
610: l_action_context_id NUMBER;
611: g_archive_pact NUMBER;
612: p_assactid NUMBER;
613: l_time_period_id per_time_periods.time_period_id%TYPE;
614: l_pre_time_period_id per_time_periods.time_period_id%TYPE;
615: l_start_date per_time_periods.start_date%TYPE;
616: l_pre_start_date per_time_periods.start_date%TYPE;
617: l_fnd_session NUMBER := 0;

Line 614: l_pre_time_period_id per_time_periods.time_period_id%TYPE;

610: l_action_context_id NUMBER;
611: g_archive_pact NUMBER;
612: p_assactid NUMBER;
613: l_time_period_id per_time_periods.time_period_id%TYPE;
614: l_pre_time_period_id per_time_periods.time_period_id%TYPE;
615: l_start_date per_time_periods.start_date%TYPE;
616: l_pre_start_date per_time_periods.start_date%TYPE;
617: l_fnd_session NUMBER := 0;
618: l_prev_prepay NUMBER := 0;

Line 615: l_start_date per_time_periods.start_date%TYPE;

611: g_archive_pact NUMBER;
612: p_assactid NUMBER;
613: l_time_period_id per_time_periods.time_period_id%TYPE;
614: l_pre_time_period_id per_time_periods.time_period_id%TYPE;
615: l_start_date per_time_periods.start_date%TYPE;
616: l_pre_start_date per_time_periods.start_date%TYPE;
617: l_fnd_session NUMBER := 0;
618: l_prev_prepay NUMBER := 0;
619: l_action_info_id pay_action_information.action_information_id%TYPE;

Line 616: l_pre_start_date per_time_periods.start_date%TYPE;

612: p_assactid NUMBER;
613: l_time_period_id per_time_periods.time_period_id%TYPE;
614: l_pre_time_period_id per_time_periods.time_period_id%TYPE;
615: l_start_date per_time_periods.start_date%TYPE;
616: l_pre_start_date per_time_periods.start_date%TYPE;
617: l_fnd_session NUMBER := 0;
618: l_prev_prepay NUMBER := 0;
619: l_action_info_id pay_action_information.action_information_id%TYPE;
620: l_ovn pay_action_information.object_version_number%TYPE;