DBA Data[Home] [Help]

APPS.PAY_NZ_REC_PKG dependencies on PER_ASSIGNMENTS_F

Line 42: /*Bug #3306269 - Added per_assignments_f with date_effective checks, and

38: v_payment_date per_time_periods.regular_payment_date%type := null;
39:
40: v_start_of_year_day constant varchar2(5) := '01-04';
41:
42: /*Bug #3306269 - Added per_assignments_f with date_effective checks, and
43: added action_status check for ppa and pac */
44: /* Bug #4200412 - Added p_time_period_id */
45: cursor min_sequence
46: (c_assignment_id in pay_assignment_actions.assignment_id%type,

Line 50: from per_assignments_f paf,

46: (c_assignment_id in pay_assignment_actions.assignment_id%type,
47: c_period_payment_date in per_time_periods.regular_payment_date%type) is
48:
49: select min(pac.action_sequence)
50: from per_assignments_f paf,
51: per_time_periods ptp,
52: pay_payroll_actions ppa,
53: pay_assignment_actions pac
54: where paf.assignment_id = c_assignment_id