DBA Data[Home] [Help]

APPS.PAY_KR_SAMPLE_SEP_PKG dependencies on PER_ASSIGNMENTS_F

Line 181: per_assignments_f pa

177: is
178: select greatest(pa.effective_start_date,p_start_date) effective_start_date,
179: least(pa.effective_end_date,p_end_date) effective_end_date
180: from per_assignment_status_types past,
181: per_assignments_f pa
182: where pa.assignment_id = p_assignment_id
183: and pa.effective_end_date >= p_start_date
184: and pa.effective_start_date <= p_end_date
185: and past.assignment_status_type_id = pa.assignment_status_type_id

Line 428: per_assignments_f pa,

424: ppa.effective_date effective_date
425: from
426: -- per_time_periods ptp,
427: per_assignment_status_types past,
428: per_assignments_f pa,
429: pay_payroll_actions ppa,
430: pay_run_types_f prt,
431: pay_assignment_actions paa
432: where paa.assignment_id = p_assignment_id

Line 555: per_assignments_f pa,

551: ptp.start_date target_start_date,
552: ptp.end_date target_end_date
553: from per_time_periods ptp,
554: per_assignment_status_types past,
555: per_assignments_f pa,
556: pay_payroll_actions ppa,
557: pay_run_types_f prt,
558: pay_assignment_actions paa,
559: -- per_time_periods bptp,