APPS.PAY_COSTING_DETAIL_REP_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1315: p_TAX_UNIT_ID pay_assignment_actions.TAX_UNIT_ID%TYPE,

1311:
1312: END costing_extract;
1313:
1314: function get_costing_tax_unit_id(p_ACTION_TYPE pay_payroll_actions.action_type%TYPE,
1315: p_TAX_UNIT_ID pay_assignment_actions.TAX_UNIT_ID%TYPE,
1316: p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,
1317: p_element_type_id pay_element_types_f.element_type_id%TYPE
1318: ) return number IS
1319: CURSOR c_tax_unit is

Line 1316: p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,

1312: END costing_extract;
1313:
1314: function get_costing_tax_unit_id(p_ACTION_TYPE pay_payroll_actions.action_type%TYPE,
1315: p_TAX_UNIT_ID pay_assignment_actions.TAX_UNIT_ID%TYPE,
1316: p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,
1317: p_element_type_id pay_element_types_f.element_type_id%TYPE
1318: ) return number IS
1319: CURSOR c_tax_unit is
1320: select paa.tax_unit_id

Line 1322: PAY_ASSIGNMENT_ACTIONS paa,

1318: ) return number IS
1319: CURSOR c_tax_unit is
1320: select paa.tax_unit_id
1321: from pay_run_results prr,
1322: PAY_ASSIGNMENT_ACTIONS paa,
1323: pay_action_interlocks pai
1324: where paa.assignment_action_id = prr.assignment_action_id
1325: AND paa.assignment_action_id = pai.LOCKED_ACTION_ID
1326: and pai.locking_action_id = p_assignment_action_id

Line 1328: L_TAX_UNIT_ID pay_assignment_actions.TAX_UNIT_ID%TYPE;

1324: where paa.assignment_action_id = prr.assignment_action_id
1325: AND paa.assignment_action_id = pai.LOCKED_ACTION_ID
1326: and pai.locking_action_id = p_assignment_action_id
1327: and prr.element_type_id = p_element_type_id;
1328: L_TAX_UNIT_ID pay_assignment_actions.TAX_UNIT_ID%TYPE;
1329: BEGIN
1330: IF P_ACTION_TYPE = 'EC' THEN
1331: return P_TAX_UNIT_ID;
1332: ELSE