DBA Data[Home] [Help]

APPS.GHR_PROC_FUT_MT dependencies on PER_ALL_PEOPLE

Line 123: l_person_id per_all_people.person_id%type;

119: FROM GHR_MTS_TEMP
120: WHERE session_id = c_session_id;
121:
122: -- Declaration of Local variables
123: l_person_id per_all_people.person_id%type;
124: l_effective_date ghr_pa_requests.effective_date%type;
125: l_batch_size NUMBER;
126: l_thread_size NUMBER;
127: l_batch_no NUMBER;

Line 140: l_curr_business_group_id per_all_people_f.business_group_id%type;

136: l_result VARCHAR2(200);
137: l_status BOOLEAN;
138: l_count NUMBER;
139: -- Bug # 7510344
140: l_curr_business_group_id per_all_people_f.business_group_id%type;
141:
142: rphase varchar2(80);
143: rstatus varchar2(80);
144: dphase varchar2(30);

Line 547: l_bus_group_id per_all_people_f.business_group_id%type;

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:
547: l_bus_group_id per_all_people_f.business_group_id%type;
548: -- End of Bug # 7510344
549:
550:
551: BEGIN