APPS.PAY_NZ_EDF dependencies on PAY_PAYROLL_ACTIONS

Line 46: PROCEDURE range_code(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,

42: select a range of assignments eligible for archival.
43: --------------------------------------------------------------------
44: */
45:
46: PROCEDURE range_code(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
47: p_sql OUT NOCOPY VARCHAR2)
48: IS
49:
50: l_proc_name VARCHAR2(100) := g_proc_name ||'range_code';

Line 62: ' pay_payroll_actions pa' ||

58: END if;
59:
60: p_sql := ' select distinct p.person_id' ||
61: ' from per_people_f p,' ||
62: ' pay_payroll_actions pa' ||
63: ' where pa.payroll_action_id = :payroll_action_id' ||
64: ' and p.business_group_id = pa.business_group_id' ||
65: ' order by p.person_id';
66:

Line 88: PROCEDURE assignment_action_code(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,

84: /* 9299387 - The assignment actions created by archival process are
85: not used by any other process.Hence,to avoid redudancy ,the
86: assignment action creation code is removed from the procedure. */
87:
88: PROCEDURE assignment_action_code(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
89: p_start_person_id IN per_all_people_f.person_id%TYPE,
90: p_end_person_id IN per_all_people_f.person_id%TYPE,
91: p_chunk IN NUMBER)
92: IS

Line 248: l_leg_param pay_payroll_actions.legislative_parameters%TYPE ;

244: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
245: l_tax_unit_id hr_organization_units.organization_id%TYPE;
246: l_effective_start_date VARCHAR2(20);
247: l_effective_end_date VARCHAR2(20);
248: l_leg_param pay_payroll_actions.legislative_parameters%TYPE ;
249: l_prd_end_date_ch VARCHAR2(20);
250: l_prd_end_date_fmt VARCHAR2(20);
251: l_payroll_action_id number;
252: l_bg_name per_business_groups.name%TYPE;

Line 256: CURSOR get_parameters(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

252: l_bg_name per_business_groups.name%TYPE;
253: l_bus_group_id per_business_groups.business_group_id%TYPE;
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),

Line 262: FROM pay_payroll_actions ppa

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,
266: c_registered_employer_id hr_organization_units.organization_id%TYPE)

Line 328: pay_payroll_actions pact

324: pay_run_result_values target,
325: pay_run_results rr,
326: pay_balance_feeds_f feed,
327: pay_assignment_actions assact,
328: pay_payroll_actions pact
329: WHERE o.business_group_id = c_business_group_id
330: AND o.organization_id = c_registered_employer_id
331: AND i.organization_id = o.organization_id
332: AND i.org_information_context = 'NZ_IRD_EMPLOYER'