APPS.PAY_NO_ARCHIVE_ABSENCE dependencies on PAY_PAYROLL_ACTIONS

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

13: p_parameter_string IN VARCHAR2
14: ,p_token IN VARCHAR2
15: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
16: IS
17: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
18: l_start_pos NUMBER;
19: l_delimiter VARCHAR2(1):=' ';
20: l_proc VARCHAR2(40):= g_package||' get parameter ';
21: BEGIN

Line 73: FROM pay_payroll_actions

69: (legislative_parameters,'END_DATE'))
70: ,PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER(legislative_parameters,'ARCHIVE')
71: ,effective_date
72: ,business_group_id
73: FROM pay_payroll_actions
74: WHERE payroll_action_id = p_payroll_action_id;
75: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
76: --
77: BEGIN

Line 231: ,pay_payroll_actions ppa

227: IS
228: Begin
229: p_sql := 'SELECT DISTINCT person_id
230: FROM per_people_f ppf
231: ,pay_payroll_actions ppa
232: WHERE ppa.payroll_action_id = :payroll_action_id
233: AND ppa.business_group_id = ppf.business_group_id
234: ORDER BY ppf.person_id';
235: