APPS.PAY_FI_ARCHIVE_ACRA dependencies on PAY_ELEMENT_SETS

Line 127: l_element_set_name pay_element_sets.element_set_name%TYPE;

123: l_emp_name hr_organization_units.name%TYPE;
124: l_le_name hr_organization_units.name%TYPE ;
125: l_lu_name hr_organization_units.name%TYPE ;
126: l_element_name pay_element_types_f.element_name%TYPE;
127: l_element_set_name pay_element_sets.element_set_name%TYPE;
128: l_business_id hr_organization_information.org_information1%TYPE ;
129: l_y_number hr_organization_information.org_information1%TYPE ;
130: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
131: l_element_type_id pay_element_types_f.element_type_id%TYPE ;

Line 183: pay_element_sets.element_set_id%TYPE)

179: AND (business_group_id=l_business_group_id
180: OR legislation_code='FI');
181: rg_Element_Details csr_Element_Details%rowtype;
182: Cursor csr_ElementSet_Details(csr_v_element_set_id
183: pay_element_sets.element_set_id%TYPE)
184: IS
185: SELECT element_set_name
186: FROM pay_element_sets
187: WHERE element_set_id=csr_v_element_set_id

Line 186: FROM pay_element_sets

182: Cursor csr_ElementSet_Details(csr_v_element_set_id
183: pay_element_sets.element_set_id%TYPE)
184: IS
185: SELECT element_set_name
186: FROM pay_element_sets
187: WHERE element_set_id=csr_v_element_set_id
188: AND (business_group_id=l_business_group_id
189: OR legislation_code='FI');
190: rg_ElementSet_Details csr_ElementSet_Details%rowtype;

Line 192: pay_element_sets.element_set_id%TYPE)

188: AND (business_group_id=l_business_group_id
189: OR legislation_code='FI');
190: rg_ElementSet_Details csr_ElementSet_Details%rowtype;
191: Cursor csr_ElementSet_Members(csr_v_element_set_id
192: pay_element_sets.element_set_id%TYPE)
193: IS
194: SELECT element_type_id
195: FROM pay_element_set_members
196: WHERE element_set_id=csr_v_element_set_id;