APPS.PQP_GB_SWF_EXTRACT dependencies on PAY_PAYROLL_ACTIONS

Line 33: g_request_id pay_payroll_actions.request_id%type;

29: g_package constant varchar2(20):= 'PQP_GB_SWF_EXTRACT.';
30:
31: -- Parameters
32: g_census_year number;
33: g_request_id pay_payroll_actions.request_id%type;
34: g_output_dir varchar2(400);
35: g_serial_number number;
36:
37: -- Process Details

Line 38: g_payroll_action_id pay_payroll_actions.payroll_action_id%type;

34: g_output_dir varchar2(400);
35: g_serial_number number;
36:
37: -- Process Details
38: g_payroll_action_id pay_payroll_actions.payroll_action_id%type;
39: g_census_date date;
40: g_lea_number number;
41: g_data_return_type varchar2(10);
42: g_estab_number varchar2(10);

Line 598: from pay_payroll_actions ppa

594: ,upper(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'DATA_RETURN_TYPE')) data_return_type
595: ,NVL(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'ESTB_NUM'),'All') estab_number
596: ,pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'EXCLUDE_ABS') exclude_abs
597: ,pay_gb_eoy_archive.get_parameter(legislative_parameters,'EXCLUDE_QUAL') exclude_qual
598: from pay_payroll_actions ppa
599: where ppa.request_id = p_request_id;
600:
601: cursor c_all_staff is
602: select distinct pai.action_information1 person_id

Line 674: -- Retrive the Process Details from pay_payroll_actions

670: g_output_dir := p_output_dir;
671: g_request_id := fnd_global.conc_request_id;
672: g_serial_number := p_serial_number;
673:
674: -- Retrive the Process Details from pay_payroll_actions
675: open c_process_details;
676: fetch c_process_details into g_payroll_action_id,g_lea_number,g_census_date,
677: g_data_return_type,g_estab_number,g_exclude_absence,g_exclude_qual;
678: close c_process_details;