APPS.GHR_PROC_FUT_MT dependencies on PER_PEOPLE_F

Line 39: FROM per_people_f per

35: AND position_id = NVL(a.to_position_id,a.from_position_id))
36: AND action_taken = 'FUTURE_ACTION'
37: AND EXISTS
38: (SELECT 1
39: FROM per_people_f per
40: WHERE per.person_id = a.person_id
41: AND a.effective_date BETWEEN
42: per.effective_start_date AND per.effective_end_date )
43: AND b.pa_routing_history_id = (SELECT max(pa_routing_history_id)

Line 64: FROM per_people_f per

60: AND position_id = NVL(a.to_position_id,a.from_position_id))
61: AND action_taken = 'FUTURE_ACTION'
62: AND EXISTS
63: (SELECT 1
64: FROM per_people_f per
65: WHERE per.person_id = a.person_id
66: AND a.effective_date BETWEEN
67: per.effective_start_date AND per.effective_end_date )
68: AND b.pa_routing_history_id = (SELECT max(pa_routing_history_id)

Line 88: FROM per_people_f per

84: AND noa.code = a.first_noa_code
85: AND action_taken = 'FUTURE_ACTION'
86: AND EXISTS
87: (SELECT 1
88: FROM per_people_f per
89: WHERE per.person_id = a.person_id
90: AND a.effective_date BETWEEN
91: per.effective_start_date AND per.effective_end_date )
92: AND b.pa_routing_history_id = (SELECT max(pa_routing_history_id)

Line 109: FROM per_people_f per

105: AND noa.code = a.first_noa_code
106: AND action_taken = 'FUTURE_ACTION'
107: AND EXISTS
108: (SELECT 1
109: FROM per_people_f per
110: WHERE per.person_id = a.person_id
111: AND a.effective_date BETWEEN
112: per.effective_start_date AND per.effective_end_date )
113: AND b.pa_routing_history_id = (SELECT max(pa_routing_history_id)

Line 538: cursor c_per_bus_group_id(p_person_id in per_people_f.person_id%TYPE,

534:
535: -- End of Bug 3602261
536:
537: -- Bug # 7510344
538: cursor c_per_bus_group_id(p_person_id in per_people_f.person_id%TYPE,
539: p_effective_date in date)
540: is
541: select ppf.business_group_id
542: from per_people_f ppf

Line 542: from per_people_f ppf

538: cursor c_per_bus_group_id(p_person_id in per_people_f.person_id%TYPE,
539: p_effective_date in date)
540: is
541: select ppf.business_group_id
542: from per_people_f ppf
543: where ppf.person_id = p_person_id
544: and p_effective_date between ppf.effective_start_date
545: and ppf.effective_end_date;
546:

Line 974: FROM per_people_f per

970: AND a.pa_request_id = b.pa_request_id
971: AND action_taken = 'FUTURE_ACTION'
972: AND EXISTS
973: (SELECT 1
974: FROM per_people_f per
975: WHERE per.person_id = a.person_id
976: AND a.effective_date BETWEEN
977: per.effective_start_date AND per.effective_end_date )
978: AND b.pa_routing_history_id = (SELECT max(pa_routing_history_id)