DBA Data[Home] [Help]

APPS.PA_UTILS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 510: per_assignment_status_types s

506: max(a.organization_id)
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'

Line 770: per_assignment_status_types s

766: max(a.job_id)
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'

Line 796: per_assignment_status_types s

792: a.job_id
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'

Line 1601: per_assignment_status_types s

1597: INTO
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