DBA Data[Home] [Help]

APPS.PAY_MX_PTU_CALC dependencies on PAY_ACTION_INFORMATION

Line 1062: pay_action_information_api.create_action_information(

1058:
1059: -- ln_factor_F_total := ROUND( ln_factor_F_total, 4 );
1060: -- ln_factor_G_total := ROUND( ln_factor_G_total, 4 );
1061:
1062: pay_action_information_api.create_action_information(
1063: p_action_information_id => ln_action_information_id
1064: ,p_object_version_number => ln_object_version_number
1065: ,p_action_information_category => 'MX PROFIT SHARING FACTORS'
1066: ,p_action_context_id => p_payroll_action_id

Line 1197: FROM pay_action_information pai

1193: CURSOR c_get_factors (cp_payroll_action_id NUMBER)
1194: IS
1195: SELECT NVL (SUM( NVL(pai.action_information2,0) ), 0) Factor_F,
1196: NVL (SUM( NVL(pai.action_information3,0) ), 0) Factor_G
1197: FROM pay_action_information pai
1198: WHERE pai.action_context_id = cp_payroll_action_id
1199: AND pai.action_context_type = 'PA'
1200: AND pai.action_information_category = 'MX PROFIT SHARING FACTORS';
1201:

Line 1665: created in PAY_ACTION_INFORMATION for the Profit

1661:
1662: /************************************************************
1663: Name : deinit_code
1664: Purpose : This procedure deletes the temporary records
1665: created in PAY_ACTION_INFORMATION for the Profit
1666: Sharing process in Mexico.
1667: Arguments : p_payroll_action_id IN NUMBER
1668: Notes :
1669: ************************************************************/

Line 1685: FROM pay_action_information

1681: ln_step := 1;
1682: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1683:
1684: DELETE
1685: FROM pay_action_information
1686: WHERE action_information_category = 'MX PROFIT SHARING FACTORS'
1687: AND action_context_id = p_payroll_action_id
1688: AND action_context_type = 'PA';
1689: