APPS.PAY_NZ_REC_PKG dependencies on PAY_BALANCE_FEEDS_F

Line 255: p_effective_start_date out nocopy pay_balance_feeds_f.effective_start_date%type)

251: p_assignment_id in pay_assignment_actions.assignment_id%type,
252: p_element_type_id in pay_element_types_f.element_type_id%type,
253: p_assignment_action_id out nocopy pay_assignment_actions.assignment_action_id%type,
254: p_balance_type_id out nocopy pay_balance_types.balance_type_id%type,
255: p_effective_start_date out nocopy pay_balance_feeds_f.effective_start_date%type)
256: return boolean is
257:
258: v_input_value_name constant pay_input_values_f.name%type := 'Pay Value';
259: v_uom constant pay_input_values_f.uom%type := 'M';

Line 273: pay_balance_feeds_f pbf,

269: pbf.balance_type_id,
270: pbf.effective_start_date
271: from pay_element_types_f pet,
272: pay_input_values_f piv,
273: pay_balance_feeds_f pbf,
274: pay_payroll_actions ppa,
275: pay_assignment_actions pac,
276: pay_run_results prr
277: where ppa.payroll_action_id = c_payroll_action_id

Line 288: from pay_balance_feeds_f pbf_not

284: and pet.element_type_id = piv.element_type_id
285: and pet.element_type_id = prr.element_type_id
286: and piv.input_value_id = pbf.input_value_id
287: and not exists (select null
288: from pay_balance_feeds_f pbf_not
289: where pbf_not.balance_feed_id <> pbf.balance_feed_id
290: and pbf_not.balance_type_id = pbf.balance_type_id
291: and (ppa.effective_date between pbf_not.effective_start_date
292: and pbf_not.effective_end_date))

Line 330: p_effective_start_date pay_balance_feeds_f.effective_start_date%type;

326: return number is
327:
328: p_assignment_action_id pay_assignment_actions.assignment_action_id%type;
329: p_balance_type_id pay_balance_types.balance_type_id%type;
330: p_effective_start_date pay_balance_feeds_f.effective_start_date%type;
331: v_value_ptd number := 0;
332:
333: begin
334: if single_feed_balance (p_payroll_action_id,

Line 367: p_effective_start_date pay_balance_feeds_f.effective_start_date%type;

363: return number is
364:
365: p_assignment_action_id pay_assignment_actions.assignment_action_id%type;
366: p_balance_type_id pay_balance_types.balance_type_id%type;
367: p_effective_start_date pay_balance_feeds_f.effective_start_date%type;
368: v_value_ytd number := 0;
369:
370: begin
371: if single_feed_balance (p_payroll_action_id,