APPS.PO_AME_WF_PVT dependencies on PER_ALL_ASSIGNMENTS_F

Line 536: per_all_assignments_f asg,

532: SELECT person_id, full_name
533: INTO l_next_approver_id, l_next_approver_name
534: FROM ( SELECT person.person_id, person.full_name
535: FROM per_all_people_f person,
536: per_all_assignments_f asg,
537: wf_users wu
538: WHERE asg.position_id = g_next_approvers(l_approver_index).orig_system_id
539: AND wu.orig_system = ame_util.perorigsystem
540: AND wu.orig_system_id = person.person_id

Line 861: per_all_assignments_f asg,

857: SELECT person_id , full_name
858: INTO l_next_approver_id, l_next_approver_name
859: FROM ( SELECT person.person_id , person.full_name
860: FROM per_all_people_f person ,
861: per_all_assignments_f asg,
862: wf_users wu
863: WHERE asg.position_id = g_next_approvers (l_approver_index).orig_system_id
864: AND wu.orig_system = ame_util.perorigsystem
865: AND wu.orig_system_id = person.person_id

Line 3862: per_all_assignments_f asg,

3858: SELECT person_id
3859: INTO l_person_id
3860: FROM ( SELECT person.person_id
3861: FROM per_all_people_f person,
3862: per_all_assignments_f asg,
3863: wf_users wu
3864: WHERE asg.position_id = l_orig_system_id
3865: AND wu.orig_system = ame_util.perorigsystem
3866: AND wu.orig_system_id = person.person_id

Line 5339: per_all_assignments_f asg ,

5335: SELECT person_id , full_name
5336: INTO l_next_approver_id, l_next_approver_name
5337: FROM ( SELECT person.person_id , person.full_name
5338: FROM per_all_people_f person ,
5339: per_all_assignments_f asg ,
5340: wf_users wu
5341: WHERE asg.position_id = ApproverList(l_approver_index).orig_system_id
5342: AND wu.orig_system = ame_util.perorigsystem
5343: AND wu.orig_system_id = person.person_id