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 334: from pay_payroll_actions pa1

330: --
331: select pay_core_utils.get_parameter('REMOVE_ACT',
332: pa1.legislative_parameters)
333: into remove_act
334: from pay_payroll_actions pa1
335: where pa1.payroll_action_id = pactid;
336: --
337: if (remove_act is null or remove_act = 'Y') then
338: del_file_details(pactid);