eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_UTILS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 522: per_assignment_status_types s

518: max(a.organization_id)
519: INTO
520: X_org_id
521: FROM
522: per_assignment_status_types s
523: , per_all_assignments_f a -- Modified for bug 4699231
524: WHERE
525: a.person_id = X_person_id
526: AND a.primary_flag = 'Y'

Line 550: per_assignment_status_types s

546: max(a.organization_id)
547: INTO
548: X_org_id
549: FROM
550: per_assignment_status_types s
551: , per_all_assignments_f a -- Modified for bug 4699231
552: WHERE
553: a.person_id = X_person_id
554: AND a.primary_flag = 'Y'

Line 842: per_assignment_status_types s

838: max(a.job_id)
839: INTO
840: X_emp_job_id
841: FROM
842: per_assignment_status_types s
843: , per_all_assignments_f a -- Modified for bug 4699231
844: WHERE
845: a.job_id IS NOT NULL
846: AND a.primary_flag = 'Y'

Line 870: per_assignment_status_types s

866: max(a.job_id)
867: INTO
868: X_emp_job_id
869: FROM
870: per_assignment_status_types s
871: , per_all_assignments_f a -- Modified for bug 4699231
872: WHERE
873: a.job_id IS NOT NULL
874: AND a.primary_flag = 'Y'

Line 898: per_assignment_status_types s

894: a.job_id
895: INTO
896: X_emp_job_id
897: FROM
898: per_assignment_status_types s
899: , per_all_assignments_f a -- for Bug 4699231
900: WHERE
901: a.job_id IS NOT NULL
902: AND a.primary_flag = 'Y'

Line 928: per_assignment_status_types s

924: a.job_id
925: INTO
926: X_emp_job_id
927: FROM
928: per_assignment_status_types s
929: , per_all_assignments_f a -- for Bug 4699231
930: WHERE
931: a.job_id IS NOT NULL
932: AND a.primary_flag = 'Y'

Line 1855: per_assignment_status_types s

1851: INTO
1852: X_emp_job_id,
1853: X_Emp_Org_Id
1854: FROM
1855: per_assignment_status_types s
1856: , per_all_assignments_f a -- modified for Bug 4699231
1857: , pa_implementations i
1858: WHERE
1859: a.job_id IS NOT NULL

Line 1883: per_assignment_status_types s

1879: INTO
1880: X_emp_job_id,
1881: X_Emp_Org_Id
1882: FROM
1883: per_assignment_status_types s
1884: , per_all_assignments_f a -- modified for Bug 4699231
1885: , pa_implementations i
1886: WHERE
1887: a.job_id IS NOT NULL