APPS.PAY_NL_TAXOFFICE_FILE dependencies on PAY_PAYROLL_ACTIONS

Line 26: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;

22: ,p_token in varchar2
23: ,p_segment_number in number default null) RETURN varchar2
24: IS
25:
26: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
27: l_start_pos NUMBER;
28: l_delimiter varchar2(1):=' ';
29: l_proc VARCHAR2(400):= g_package||' get parameter ';
30:

Line 83: FROM pay_payroll_actions

79: ,pay_nl_taxoffice_file.get_parameter(legislative_parameters,'EMPLOYER_ID')
80: ,pay_nl_taxoffice_file.get_parameter(legislative_parameters,'ORG_HIERARCHY')
81: ,effective_date
82: ,business_group_id
83: FROM pay_payroll_actions
84: WHERE payroll_action_id = p_payroll_action_id;
85: --
86: l_effective_date date;
87: l_proc VARCHAR2(400):= g_package||' get_all_parameters ';

Line 236: ,pay_payroll_actions ppa

232:
233: IF g_error_count=0 THEN
234: sqlstr := 'SELECT DISTINCT person_id
235: FROM per_people_f ppf
236: ,pay_payroll_actions ppa
237: WHERE ppa.payroll_action_id = :payroll_action_id
238: AND ppa.business_group_id = ppf.business_group_id
239: ORDER BY ppf.person_id';
240:

Line 255: ,pay_payroll_actions ppa

251: end if;
252: ELSE
253: sqlstr := 'SELECT DISTINCT person_id
254: FROM per_people_f ppf
255: ,pay_payroll_actions ppa
256: WHERE ppa.payroll_action_id = :payroll_action_id
257: AND 1 = 2
258: AND ppa.business_group_id = ppf.business_group_id
259: ORDER BY ppf.person_id';