APPS.PSP_ENC_LIQ_TRAN dependencies on PER_PEOPLE_F

Line 738: per_people_f ppf

734: COUNT(1)
735: FROM psp_enc_summary_lines pesl,
736: psp_enc_controls pec,
737: per_assignments_f paf,
738: per_people_f ppf
739: WHERE pesl.enc_control_id = pec.enc_control_id
740: AND paf.assignment_id = pesl.assignment_id
741: AND pesl.effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
742: AND ppf.person_id = pesl.person_id

Line 1305: per_people_f ppf

1301: COUNT(1)
1302: FROM psp_enc_summary_lines pesl,
1303: psp_enc_controls pec,
1304: per_assignments_f paf,
1305: per_people_f ppf
1306: WHERE pesl.enc_control_id = pec.enc_control_id
1307: AND paf.assignment_id = pesl.assignment_id
1308: AND pesl.effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
1309: AND ppf.person_id = pesl.person_id

Line 5315: fnd_message.set_token('TABLE', 'PER_PEOPLE_F');

5311: LOOP
5312: IF r_interface.employee_number(recno) IS NULL THEN
5313: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5314: fnd_message.set_token('VALUE', 'person_id: ' || r_interface.person_id(recno));
5315: fnd_message.set_token('TABLE', 'PER_PEOPLE_F');
5316: fnd_msg_pub.add;
5317: l_raise_error := TRUE;
5318: END IF;
5319:

Line 5497: FROM per_people_f

5493: --insert_into_psp_stout( 'fetched int cur in tr to gms int');
5494: BEGIN
5495: SELECT employee_number
5496: INTO l_emp_num
5497: FROM per_people_f
5498: WHERE person_id = int_rec.person_id
5499: AND int_rec.effective_date between effective_start_date and effective_end_date;
5500: EXCEPTION
5501: WHEN NO_DATA_FOUND THEN

Line 5503: l_table := 'PER_PEOPLE_F';

5499: AND int_rec.effective_date between effective_start_date and effective_end_date;
5500: EXCEPTION
5501: WHEN NO_DATA_FOUND THEN
5502: l_value := 'Person id ='||to_char(int_rec.person_id);
5503: l_table := 'PER_PEOPLE_F';
5504: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5505: fnd_message.set_token('VALUE',l_value);
5506: fnd_message.set_token('TABLE',l_table);
5507: fnd_msg_pub.add;