154: SELECT ptp.end_date end_date,
155: ptp.start_date start_date,
156: ptp.period_name period_name,
157: ppf.payroll_name payroll_name
158: FROM per_time_periods ptp
159: ,pay_payroll_actions ppa
160: ,pay_payrolls_f ppf
161: WHERE ptp.payroll_id = ppa.payroll_id
162: AND ppa.payroll_action_id = p_run_payact_id
2558: ptp.time_period_id time_period_id,
2559: ppa.date_earned date_earned,
2560: ppa.effective_date effective_date,
2561: ptp.start_date start_date
2562: FROM per_time_periods ptp
2563: ,pay_payroll_actions ppa
2564: ,pay_assignment_actions paa
2565: WHERE ptp.payroll_id =ppa.payroll_id
2566: AND ppa.payroll_action_id =paa.payroll_action_id
2582: l_tu_id NUMBER;
2583: l_archive_payact_id NUMBER;
2584: l_record_count NUMBER;
2585: l_actid NUMBER;
2586: l_end_date per_time_periods.end_date%TYPE;
2587: l_pre_end_date per_time_periods.end_date%TYPE;
2588: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2589: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2590: l_date_earned pay_payroll_actions.date_earned%TYPE;
2583: l_archive_payact_id NUMBER;
2584: l_record_count NUMBER;
2585: l_actid NUMBER;
2586: l_end_date per_time_periods.end_date%TYPE;
2587: l_pre_end_date per_time_periods.end_date%TYPE;
2588: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2589: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2590: l_date_earned pay_payroll_actions.date_earned%TYPE;
2591: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
2584: l_record_count NUMBER;
2585: l_actid NUMBER;
2586: l_end_date per_time_periods.end_date%TYPE;
2587: l_pre_end_date per_time_periods.end_date%TYPE;
2588: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2589: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2590: l_date_earned pay_payroll_actions.date_earned%TYPE;
2591: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
2592: l_effective_date pay_payroll_actions.effective_date%TYPE;
2585: l_actid NUMBER;
2586: l_end_date per_time_periods.end_date%TYPE;
2587: l_pre_end_date per_time_periods.end_date%TYPE;
2588: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2589: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2590: l_date_earned pay_payroll_actions.date_earned%TYPE;
2591: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
2592: l_effective_date pay_payroll_actions.effective_date%TYPE;
2593: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
2594: l_run_payact_id NUMBER;
2595: l_action_context_id NUMBER;
2596: g_archive_pact NUMBER;
2597: p_assactid NUMBER;
2598: l_time_period_id per_time_periods.time_period_id%TYPE;
2599: l_pre_time_period_id per_time_periods.time_period_id%TYPE;
2600: l_start_date per_time_periods.start_date%TYPE;
2601: l_pre_start_date per_time_periods.start_date%TYPE;
2602: l_fnd_session NUMBER := 0;
2595: l_action_context_id NUMBER;
2596: g_archive_pact NUMBER;
2597: p_assactid NUMBER;
2598: l_time_period_id per_time_periods.time_period_id%TYPE;
2599: l_pre_time_period_id per_time_periods.time_period_id%TYPE;
2600: l_start_date per_time_periods.start_date%TYPE;
2601: l_pre_start_date per_time_periods.start_date%TYPE;
2602: l_fnd_session NUMBER := 0;
2603: l_prev_prepay NUMBER := 0;
2596: g_archive_pact NUMBER;
2597: p_assactid NUMBER;
2598: l_time_period_id per_time_periods.time_period_id%TYPE;
2599: l_pre_time_period_id per_time_periods.time_period_id%TYPE;
2600: l_start_date per_time_periods.start_date%TYPE;
2601: l_pre_start_date per_time_periods.start_date%TYPE;
2602: l_fnd_session NUMBER := 0;
2603: l_prev_prepay NUMBER := 0;
2604: BEGIN
2597: p_assactid NUMBER;
2598: l_time_period_id per_time_periods.time_period_id%TYPE;
2599: l_pre_time_period_id per_time_periods.time_period_id%TYPE;
2600: l_start_date per_time_periods.start_date%TYPE;
2601: l_pre_start_date per_time_periods.start_date%TYPE;
2602: l_fnd_session NUMBER := 0;
2603: l_prev_prepay NUMBER := 0;
2604: BEGIN
2605: IF g_debug THEN