175: SELECT ptp.end_date end_date,
176: ptp.start_date start_date,
177: ptp.period_name period_name,
178: ppf.payroll_name payroll_name
179: FROM per_time_periods ptp
180: ,pay_payroll_actions ppa
181: ,pay_payrolls_f ppf
182: WHERE ptp.payroll_id = ppa.payroll_id
183: AND ppa.payroll_action_id = p_run_payact_id
2353: ptp.time_period_id time_period_id,
2354: ppa.date_earned date_earned,
2355: ppa.effective_date effective_date,
2356: ptp.start_date start_date
2357: FROM per_time_periods ptp
2358: ,pay_payroll_actions ppa
2359: ,pay_assignment_actions paa
2360: WHERE ptp.payroll_id =ppa.payroll_id
2361: AND ppa.payroll_action_id =paa.payroll_action_id
2373:
2374: l_archive_payact_id NUMBER;
2375: l_record_count NUMBER;
2376: l_actid NUMBER;
2377: l_end_date per_time_periods.end_date%TYPE;
2378: l_pre_end_date per_time_periods.end_date%TYPE;
2379: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2380: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2381: l_date_earned pay_payroll_actions.date_earned%TYPE;
2374: l_archive_payact_id NUMBER;
2375: l_record_count NUMBER;
2376: l_actid NUMBER;
2377: l_end_date per_time_periods.end_date%TYPE;
2378: l_pre_end_date per_time_periods.end_date%TYPE;
2379: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2380: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2381: l_date_earned pay_payroll_actions.date_earned%TYPE;
2382: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
2375: l_record_count NUMBER;
2376: l_actid NUMBER;
2377: l_end_date per_time_periods.end_date%TYPE;
2378: l_pre_end_date per_time_periods.end_date%TYPE;
2379: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2380: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2381: l_date_earned pay_payroll_actions.date_earned%TYPE;
2382: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
2383: l_effective_date pay_payroll_actions.effective_date%TYPE;
2376: l_actid NUMBER;
2377: l_end_date per_time_periods.end_date%TYPE;
2378: l_pre_end_date per_time_periods.end_date%TYPE;
2379: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2380: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2381: l_date_earned pay_payroll_actions.date_earned%TYPE;
2382: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
2383: l_effective_date pay_payroll_actions.effective_date%TYPE;
2384: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
2385: l_run_payact_id NUMBER;
2386: l_action_context_id NUMBER;
2387: g_archive_pact NUMBER;
2388: p_assactid NUMBER;
2389: l_time_period_id per_time_periods.time_period_id%TYPE;
2390: l_pre_time_period_id per_time_periods.time_period_id%TYPE;
2391: l_start_date per_time_periods.start_date%TYPE;
2392: l_pre_start_date per_time_periods.start_date%TYPE;
2393: l_fnd_session NUMBER := 0;
2386: l_action_context_id NUMBER;
2387: g_archive_pact NUMBER;
2388: p_assactid NUMBER;
2389: l_time_period_id per_time_periods.time_period_id%TYPE;
2390: l_pre_time_period_id per_time_periods.time_period_id%TYPE;
2391: l_start_date per_time_periods.start_date%TYPE;
2392: l_pre_start_date per_time_periods.start_date%TYPE;
2393: l_fnd_session NUMBER := 0;
2394: l_prev_prepay NUMBER := 0;
2387: g_archive_pact NUMBER;
2388: p_assactid NUMBER;
2389: l_time_period_id per_time_periods.time_period_id%TYPE;
2390: l_pre_time_period_id per_time_periods.time_period_id%TYPE;
2391: l_start_date per_time_periods.start_date%TYPE;
2392: l_pre_start_date per_time_periods.start_date%TYPE;
2393: l_fnd_session NUMBER := 0;
2394: l_prev_prepay NUMBER := 0;
2395:
2388: p_assactid NUMBER;
2389: l_time_period_id per_time_periods.time_period_id%TYPE;
2390: l_pre_time_period_id per_time_periods.time_period_id%TYPE;
2391: l_start_date per_time_periods.start_date%TYPE;
2392: l_pre_start_date per_time_periods.start_date%TYPE;
2393: l_fnd_session NUMBER := 0;
2394: l_prev_prepay NUMBER := 0;
2395:
2396: BEGIN