APPS.PAY_FI_ARCHIVE_ACRA 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 79: FROM pay_payroll_actions

75: (legislative_parameters,'END_DATE'))
76: ,PAY_FI_ARCHIVE_ACRA.GET_PARAMETER(legislative_parameters,'ARCHIVE')
77: ,effective_date
78: ,business_group_id
79: FROM pay_payroll_actions
80: WHERE payroll_action_id = p_payroll_action_id;
81: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
82: --
83: BEGIN

Line 228: , pay_payroll_actions ppa

224: /*, pay_element_set_members pesm*/
225: , pay_costs pc
226: , pay_cost_allocation_keyflex pcak
227: , pay_assignment_actions paa
228: , pay_payroll_actions ppa
229: , per_all_assignments_f paaf
230: , hr_soft_coding_keyflex hsck
231: WHERE pet.element_type_id =l_element_type_id
232: AND (pet.business_group_id = l_business_group_id

Line 272: ,pay_payroll_actions ppa

268: hr_utility.set_location(' Entering Procedure RANGE_CODE',10);
269: END IF;
270: p_sql := 'SELECT DISTINCT person_id
271: FROM per_people_f ppf
272: ,pay_payroll_actions ppa
273: WHERE ppa.payroll_action_id = :payroll_action_id
274: AND ppa.business_group_id = ppf.business_group_id
275: ORDER BY ppf.person_id';
276: PAY_FI_ARCHIVE_ACRA.GET_ALL_PARAMETERS(