APPS.PAY_FI_ARCHIVE_PSTA dependencies on PAY_PAYROLLS_F

Line 206: l_payroll_name pay_payrolls_f.payroll_name%type;

202: l_action_info_id number;
203: l_ovn number;
204: l_postal_code hr_locations.postal_code%type;
205: l_country hr_locations.country%type;
206: l_payroll_name pay_payrolls_f.payroll_name%type;
207: begin
208: if g_debug then
209: hr_utility.set_location (' Entering Procedure RANGE_CODE', 10);
210: end if;

Line 249: from pay_payrolls_f

245: /* Get the Payroll Name */
246: if g_payroll_id is not null then
247: select payroll_name
248: into l_payroll_name
249: from pay_payrolls_f
250: where payroll_id = g_payroll_id and g_year_last_date between effective_start_date and effective_end_date;
251: end if;
252:
253: g_arch_payroll_action_id := p_payroll_action_id;

Line 380: pay_payrolls_f ppa

376: pay_action_interlocks pai,
377: per_all_assignments_f paaf,
378: hr_soft_coding_keyflex hsck,
379: hr_organization_information hoi,
380: pay_payrolls_f ppa
381: where appa.action_type in ('R', 'Q')
382: and act.payroll_action_id = appa.payroll_action_id
383: and act.source_action_id is null -- Master Action
384: and act.action_status IN ('C','S') -- 10229501