APPS.PAY_SE_HCIA_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

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

19: p_token IN VARCHAR2,
20: p_segment_number IN NUMBER DEFAULT NULL
21: )
22: RETURN VARCHAR2 IS
23: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;
24: l_start_pos NUMBER;
25: l_delimiter VARCHAR2 (1) := ' ';
26: l_proc VARCHAR2 (40) := g_package || ' get parameter ';
27: BEGIN

Line 102: FROM pay_payroll_actions

98: (pay_se_hcia_archive.get_parameter (legislative_parameters, 'EFFECTIVE_START_DATE')) eff_start_date,
99: (pay_se_hcia_archive.get_parameter (legislative_parameters, 'EFFECTIVE_END_DATE'))
100: eff_end_date,
101: effective_date effective_date, business_group_id bg_id
102: FROM pay_payroll_actions
103: WHERE payroll_action_id = p_payroll_action_id;
104:
105: lr_parameter_info csr_parameter_info%ROWTYPE;
106: l_proc VARCHAR2 (240) := g_package || ' GET_ALL_PARAMETERS ';

Line 233: ,pay_payroll_actions ppa

229:
230: p_sql :=
231: 'SELECT DISTINCT person_id
232: FROM per_people_f ppf
233: ,pay_payroll_actions ppa
234: WHERE ppa.payroll_action_id = :payroll_action_id
235: AND ppa.business_group_id = ppf.business_group_id
236: ORDER BY ppf.person_id';
237: g_payroll_action_id := p_payroll_action_id;