DBA Data[Home] [Help]

APPS.HR_US_ACCRUAL_PLANS dependencies on PER_PERIODS_OF_SERVICE

Line 52: per_periods_of_service through a

48: get_accrual_ineligibility.
49: 08-APR-99 djoshi 115.3 Verfied and converted for Canonical
50: Complience of Date
51: 15-APR-99 VMehta 115.4 764244 Accessing the
52: per_periods_of_service through a
53: date effective join
54:
55:
56: 21-Apr-99 scgrant 115.5 Multi-radix changes.

Line 167: FROM per_periods_of_service pps,

163: -- and the assignment's length of service relative to ineligible period.
164:
165: SELECT pps.date_start
166: INTO v_service_start
167: FROM per_periods_of_service pps,
168: per_assignments_f paf
169: WHERE paf.assignment_id = p_asg_id
170: AND p_sess_date BETWEEN paf.effective_start_date
171: AND paf.effective_end_date