APPS.PAY_NO_ARC_HOLIDAY_ENTITLEMENT dependencies on PAY_PAYROLL_ACTIONS

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

19: p_parameter_string IN VARCHAR2
20: ,p_token IN VARCHAR2
21: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
22: 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(240):= g_package||' get parameter ';
27: BEGIN

Line 77: FROM pay_payroll_actions

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

Line 147: ,pay_payroll_actions ppa

143: hr_utility.set_location('Report Parameters ***********',30);
144:
145: p_sql := 'SELECT DISTINCT person_id
146: FROM per_people_f ppf
147: ,pay_payroll_actions ppa
148: WHERE ppa.payroll_action_id = :payroll_action_id
149: AND ppa.business_group_id = ppf.business_group_id
150: ORDER BY ppf.person_id';
151: