DBA Data[Home] [Help]

APPS.PAY_NZ_EDF dependencies on PAY_CORE_UTILS

Line 258: SELECT pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),

254: l_session_date fnd_sessions.effective_date%TYPE; /* Bug 9612150 */
255:
256: CURSOR get_parameters(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
257: IS
258: SELECT pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
259: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters),
260: pay_core_utils.get_parameter('START_DATE',ppa.legislative_parameters),
261: pay_core_utils.get_parameter('END_DATE',ppa.legislative_parameters)
262: FROM pay_payroll_actions ppa

Line 259: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters),

255:
256: CURSOR get_parameters(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
257: IS
258: SELECT pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
259: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters),
260: pay_core_utils.get_parameter('START_DATE',ppa.legislative_parameters),
261: pay_core_utils.get_parameter('END_DATE',ppa.legislative_parameters)
262: FROM pay_payroll_actions ppa
263: WHERE ppa.payroll_action_id = c_payroll_action_id;

Line 260: pay_core_utils.get_parameter('START_DATE',ppa.legislative_parameters),

256: CURSOR get_parameters(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
257: IS
258: SELECT pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
259: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters),
260: pay_core_utils.get_parameter('START_DATE',ppa.legislative_parameters),
261: pay_core_utils.get_parameter('END_DATE',ppa.legislative_parameters)
262: FROM pay_payroll_actions ppa
263: WHERE ppa.payroll_action_id = c_payroll_action_id;
264:

Line 261: pay_core_utils.get_parameter('END_DATE',ppa.legislative_parameters)

257: IS
258: SELECT pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
259: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters),
260: pay_core_utils.get_parameter('START_DATE',ppa.legislative_parameters),
261: pay_core_utils.get_parameter('END_DATE',ppa.legislative_parameters)
262: FROM pay_payroll_actions ppa
263: WHERE ppa.payroll_action_id = c_payroll_action_id;
264:
265: CURSOR get_registered_employer(c_business_group_id hr_organization_units.business_group_id%TYPE,