APPS.PAY_FI_ARCHIVE_ACRA dependencies on PAY_ELEMENT_SET_MEMBERS

Line 133: l_element_set_id pay_element_set_members.element_set_id%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 ;
132: d_element_type_id pay_element_types_f.element_type_id%TYPE ;
133: l_element_set_id pay_element_set_members.element_set_id%TYPE;
134: l_con_Segments pay_cost_allocation_keyflex.concatenated_segments%TYPE;
135: l_cost_allocation_softflex_id pay_costs.cost_allocation_keyflex_id%TYPE;
136: l_debit_or_credit pay_costs.debit_or_credit%TYPE;
137: l_cost_value pay_costs.costed_value%TYPE;

Line 195: FROM pay_element_set_members

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;
197: rg_ElementSet_Members csr_ElementSet_Members%rowtype;
198: Cursor csr_Local_unit_Legal(csr_v_legal_unit_id
199: hr_organization_units.organization_id%TYPE)

Line 224: /*, pay_element_set_members pesm*/

220: ,sum(pc.costed_value) costed_value
221: FROM pay_element_types_f pet
222: , pay_input_values_f piv
223: , pay_run_results prr
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