DBA Data[Home] [Help]

APPS.PA_UTILS dependencies on PER_ALL_ASSIGNMENTS_F

Line 511: , per_all_assignments_f a -- Modified for bug 4699231

507: INTO
508: X_org_id
509: FROM
510: per_assignment_status_types s
511: , per_all_assignments_f a -- Modified for bug 4699231
512: WHERE
513: a.person_id = X_person_id
514: AND a.primary_flag = 'Y'
515: AND a.assignment_type in ('E', 'C')

Line 771: , per_all_assignments_f a -- Modified for bug 4699231

767: INTO
768: X_emp_job_id
769: FROM
770: per_assignment_status_types s
771: , per_all_assignments_f a -- Modified for bug 4699231
772: WHERE
773: a.job_id IS NOT NULL
774: AND a.primary_flag = 'Y'
775: AND X_date BETWEEN trunc( a.effective_start_date )

Line 797: , per_all_assignments_f a -- for Bug 4699231

793: INTO
794: X_emp_job_id
795: FROM
796: per_assignment_status_types s
797: , per_all_assignments_f a -- for Bug 4699231
798: WHERE
799: a.job_id IS NOT NULL
800: AND a.primary_flag = 'Y'
801: AND X_date BETWEEN trunc( a.effective_start_date )

Line 1602: , per_all_assignments_f a -- modified for Bug 4699231

1598: X_emp_job_id,
1599: X_Emp_Org_Id
1600: FROM
1601: per_assignment_status_types s
1602: , per_all_assignments_f a -- modified for Bug 4699231
1603: , pa_implementations i
1604: WHERE
1605: a.job_id IS NOT NULL
1606: AND a.primary_flag = 'Y'