APPS.PAY_COSTING_DETAIL_REP_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1380: p_TAX_UNIT_ID pay_assignment_actions.TAX_UNIT_ID%TYPE,

1376:
1377: END costing_extract;
1378:
1379: function get_costing_tax_unit_id(p_ACTION_TYPE pay_payroll_actions.action_type%TYPE,
1380: p_TAX_UNIT_ID pay_assignment_actions.TAX_UNIT_ID%TYPE,
1381: p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,
1382: p_element_type_id pay_element_types_f.element_type_id%TYPE
1383: ) return number IS
1384: CURSOR c_tax_unit is

Line 1381: p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,

1377: END costing_extract;
1378:
1379: function get_costing_tax_unit_id(p_ACTION_TYPE pay_payroll_actions.action_type%TYPE,
1380: p_TAX_UNIT_ID pay_assignment_actions.TAX_UNIT_ID%TYPE,
1381: p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,
1382: p_element_type_id pay_element_types_f.element_type_id%TYPE
1383: ) return number IS
1384: CURSOR c_tax_unit is
1385: select paa.tax_unit_id

Line 1387: PAY_ASSIGNMENT_ACTIONS paa,

1383: ) return number IS
1384: CURSOR c_tax_unit is
1385: select paa.tax_unit_id
1386: from pay_run_results prr,
1387: PAY_ASSIGNMENT_ACTIONS paa,
1388: pay_action_interlocks pai
1389: where paa.assignment_action_id = prr.assignment_action_id
1390: AND paa.assignment_action_id = pai.LOCKED_ACTION_ID
1391: and pai.locking_action_id = p_assignment_action_id

Line 1393: L_TAX_UNIT_ID pay_assignment_actions.TAX_UNIT_ID%TYPE;

1389: where paa.assignment_action_id = prr.assignment_action_id
1390: AND paa.assignment_action_id = pai.LOCKED_ACTION_ID
1391: and pai.locking_action_id = p_assignment_action_id
1392: and prr.element_type_id = p_element_type_id;
1393: L_TAX_UNIT_ID pay_assignment_actions.TAX_UNIT_ID%TYPE;
1394: BEGIN
1395: IF P_ACTION_TYPE = 'EC' THEN
1396: return P_TAX_UNIT_ID;
1397: ELSE