APPS.PAY_NO_SC_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

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

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

Line 74: FROM pay_payroll_actions

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

Line 138: ,pay_payroll_actions ppa

134:
135:
136: p_sql := 'SELECT DISTINCT person_id
137: FROM per_people_f ppf
138: ,pay_payroll_actions ppa
139: WHERE ppa.payroll_action_id = :payroll_action_id
140: AND ppa.business_group_id = ppf.business_group_id
141: ORDER BY ppf.person_id';
142: