APPS.PAY_SE_TRNA_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

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

40: p_token IN VARCHAR2,
41: p_segment_number IN NUMBER DEFAULT NULL
42: )
43: RETURN VARCHAR2 IS
44: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;
45: l_start_pos NUMBER;
46: l_delimiter VARCHAR2 (1) := ' ';
47: l_proc VARCHAR2 (40) := g_package || ' get parameter ';
48: BEGIN

Line 193: FROM pay_payroll_actions

189: start_date_of_birth,
190: (pay_se_trna_archive.get_parameter (legislative_parameters, 'END_DATE_OF_BIRTH')) end_date_of_birth,
191: effective_date
192: effective_date, business_group_id bg_id
193: FROM pay_payroll_actions
194: WHERE payroll_action_id = p_payroll_action_id;
195:
196: lr_parameter_info csr_parameter_info%ROWTYPE;
197: l_proc VARCHAR2 (240) := g_package || ' GET_ALL_PARAMETERS ';

Line 274: ,pay_payroll_actions ppa

270:
271: p_sql :=
272: 'SELECT DISTINCT person_id
273: FROM per_people_f ppf
274: ,pay_payroll_actions ppa
275: WHERE ppa.payroll_action_id = :payroll_action_id
276: AND ppa.business_group_id = ppf.business_group_id
277: ORDER BY ppf.person_id';
278: g_payroll_action_id := p_payroll_action_id;