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 149: l_employee_number per_people_f.employee_number%type;

145: dstatus varchar2(30);
146: message varchar2(240);
147: call_status boolean;
148: --Bug # 9329643
149: l_employee_number per_people_f.employee_number%type;
150: BEGIN
151: -- Initialization of variables.
152: l_batch_counter := 0;
153: l_batch_no := 1;

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

548:
549: -- End of Bug 3602261
550:
551: -- Bug # 7510344
552: cursor c_per_bus_group_id(p_person_id in per_people_f.person_id%TYPE,
553: p_effective_date in date)
554: is
555: select ppf.business_group_id
556: from per_people_f ppf

Line 556: from per_people_f ppf

552: cursor c_per_bus_group_id(p_person_id in per_people_f.person_id%TYPE,
553: p_effective_date in date)
554: is
555: select ppf.business_group_id
556: from per_people_f ppf
557: where ppf.person_id = p_person_id
558: and p_effective_date between ppf.effective_start_date
559: and ppf.effective_end_date;
560:

Line 565: l_employee_number per_people_f.employee_number%type;

561: l_bus_group_id per_all_people_f.business_group_id%type;
562: -- End of Bug # 7510344
563:
564: --Bug # 9329643
565: l_employee_number per_people_f.employee_number%type;
566:
567: BEGIN
568:
569: FOR s_id IN c_sessionid

Line 922: l_employee_number per_people_f.employee_number%type;

918: l_proc varchar2(30);
919: l_new_line varchar2(1);
920: l_sf52 ghr_pa_requests%rowtype ;
921: --Bug # 9329643
922: l_employee_number per_people_f.employee_number%type;
923: Begin
924: l_proc := 'Route_Errerd_SF52';
925: l_new_line := substr('
926: ',1,1);

Line 1004: FROM per_people_f per

1000: AND a.pa_request_id = b.pa_request_id
1001: AND action_taken = 'FUTURE_ACTION'
1002: AND EXISTS
1003: (SELECT 1
1004: FROM per_people_f per
1005: WHERE per.person_id = a.person_id
1006: AND a.effective_date BETWEEN
1007: per.effective_start_date AND per.effective_end_date )
1008: AND b.pa_routing_history_id = (SELECT max(pa_routing_history_id)