DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_ACRA dependencies on PAY_COSTS

Line 135: l_cost_allocation_softflex_id pay_costs.cost_allocation_keyflex_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;
138: credit pay_costs.costed_value%TYPE;
139: debit pay_costs.costed_value%TYPE;

Line 136: l_debit_or_credit pay_costs.debit_or_credit%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;
138: credit pay_costs.costed_value%TYPE;
139: debit pay_costs.costed_value%TYPE;
140: l_counter number := 0;

Line 137: l_cost_value pay_costs.costed_value%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;
138: credit pay_costs.costed_value%TYPE;
139: debit pay_costs.costed_value%TYPE;
140: l_counter number := 0;
141: l_archive VARCHAR2(3);

Line 138: credit pay_costs.costed_value%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;
138: credit pay_costs.costed_value%TYPE;
139: debit pay_costs.costed_value%TYPE;
140: l_counter number := 0;
141: l_archive VARCHAR2(3);
142: /* Cursors */

Line 139: debit pay_costs.costed_value%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;
138: credit pay_costs.costed_value%TYPE;
139: debit pay_costs.costed_value%TYPE;
140: l_counter number := 0;
141: l_archive VARCHAR2(3);
142: /* Cursors */
143: Cursor csr_Local_Unit_Details ( csr_v_local_unit_id

Line 225: , pay_costs pc

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
229: , per_all_assignments_f paaf