DBA Data[Home] [Help]

APPS.PAY_CORE_XDO_UTILS dependencies on PAY_PAYROLL_ACTIONS

Line 10: FROM pay_payroll_actions

6:
7: -- Get request_id
8: CURSOR get_request_id (c_pact_id NUMBER)IS
9: SELECT request_id
10: FROM pay_payroll_actions
11: WHERE payroll_action_id = c_pact_id;
12:
13: -- Get Application Short Name and Application ID
14: CURSOR get_application_detais(c_request_id NUMBER) IS

Line 39: pay_payroll_actions ppa,

35: nvl(prd.application_short_name,'PAY'),
36: prv.definition_type,
37: prv.report_variable_id
38: FROM pay_report_groups prg,
39: pay_payroll_actions ppa,
40: pay_report_definitions prd,
41: pay_report_categories prc,
42: pay_report_category_components prcc,
43: pay_report_variables prv

Line 320: from pay_payroll_actions pa1

316: --
317: select pay_core_utils.get_parameter('REMOVE_ACT',
318: pa1.legislative_parameters)
319: into remove_act
320: from pay_payroll_actions pa1
321: where pa1.payroll_action_id = pactid;
322: --
323: if (remove_act is null or remove_act = 'Y') then
324: del_file_details(pactid);