APPS.PAY_GB_ENROLL_INFO_GENE dependencies on PER_ALL_PEOPLE_F

Line 135: per_all_people_f papf,

131:
132:
133: CURSOR c_person_details(p_assignment_id number) IS
134: SELECT papf.full_name, papf.email_address, papf.person_id FROM
135: per_all_people_f papf,
136: per_all_assignments_f paaf
137: WHERE
138: papf.person_id=paaf.person_id
139: AND paaf.assignment_id = p_assignment_id

Line 203: select assignment_number,full_name from per_all_people_f papf,per_all_assignments_f paaf

199: order by action_context_id desc;-- LAtest archive data in that period
200:
201: --Summary Info
202: cursor c_summary_details(p_assignment_id number) is
203: select assignment_number,full_name from per_all_people_f papf,per_all_assignments_f paaf
204: where papf.person_id = paaf.person_id
205: and paaf.assignment_id = p_assignment_id
206: and l_prp_end_date between papf.effective_start_date and papf.effective_end_date
207: and l_prp_end_date between paaf.effective_start_date and paaf.effective_end_date;

Line 262: l_employee_name per_all_people_f.full_name%type:= NULL;

258: l_pension_age number := 65;
259: l_not varchar2(3) :='not';
260: --------------------------------------
261: l_employer_name VARCHAR2(150):= NULL;
262: l_employee_name per_all_people_f.full_name%type:= NULL;
263: l_email_address per_all_people_f.email_address%type:= NULL;
264: l_period pay_payrolls_f.period_type%type:= NULL;
265: l_earning ff_globals_f.global_value%type:= NULL;
266: l_earning_lower ff_globals_f.global_value%type:= NULL;

Line 263: l_email_address per_all_people_f.email_address%type:= NULL;

259: l_not varchar2(3) :='not';
260: --------------------------------------
261: l_employer_name VARCHAR2(150):= NULL;
262: l_employee_name per_all_people_f.full_name%type:= NULL;
263: l_email_address per_all_people_f.email_address%type:= NULL;
264: l_period pay_payrolls_f.period_type%type:= NULL;
265: l_earning ff_globals_f.global_value%type:= NULL;
266: l_earning_lower ff_globals_f.global_value%type:= NULL;
267:

Line 1186: l_employee_name per_all_people_f.full_name%type;

1182: l_xml CLOB;
1183: EOL VARCHAR2(5) := fnd_global.local_chr(10);
1184: l_req_id varchar2(20);
1185: l_assignment_number per_all_assignments_f.assignment_number%type;
1186: l_employee_name per_all_people_f.full_name%type;
1187: /*
1188:
1189: t_string VARCHAR2(32767) := NULL;
1190:

Line 1205: l_employee_name per_all_people_f.full_name%type:= NULL;

1201: l_not varchar2(3) :='not';
1202:
1203: --------------------------------------
1204: l_employer_name VARCHAR2(150):= NULL;
1205: l_employee_name per_all_people_f.full_name%type:= NULL;
1206: l_period pay_payrolls_f.period_type%type:= NULL;
1207: l_earning ff_globals_f.global_value%type:= NULL;
1208: l_earning_lower ff_globals_f.global_value%type:= NULL;
1209: