APPS.PSP_ENC_LIQ_TRAN dependencies on PER_PEOPLE_F

Line 740: per_people_f ppf

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

Line 1314: per_people_f ppf

1310: COUNT(1)
1311: FROM psp_enc_summary_lines pesl,
1312: psp_enc_controls pec,
1313: per_assignments_f paf,
1314: per_people_f ppf
1315: WHERE pesl.enc_control_id = pec.enc_control_id
1316: AND paf.assignment_id = pesl.assignment_id
1317: AND pesl.effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
1318: AND ppf.person_id = pesl.person_id

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

5392: LOOP
5393: IF r_interface.employee_number(recno) IS NULL THEN
5394: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5395: fnd_message.set_token('VALUE', 'person_id: ' || r_interface.person_id(recno));
5396: fnd_message.set_token('TABLE', 'PER_PEOPLE_F');
5397: fnd_msg_pub.add;
5398: l_raise_error := TRUE;
5399: END IF;
5400:

Line 5592: FROM per_people_f

5588: --insert_into_psp_stout( 'fetched int cur in tr to gms int');
5589: BEGIN
5590: SELECT employee_number
5591: INTO l_emp_num
5592: FROM per_people_f
5593: WHERE person_id = int_rec.person_id
5594: AND int_rec.effective_date between effective_start_date and effective_end_date;
5595: EXCEPTION
5596: WHEN NO_DATA_FOUND THEN

Line 5598: l_table := 'PER_PEOPLE_F';

5594: AND int_rec.effective_date between effective_start_date and effective_end_date;
5595: EXCEPTION
5596: WHEN NO_DATA_FOUND THEN
5597: l_value := 'Person id ='||to_char(int_rec.person_id);
5598: l_table := 'PER_PEOPLE_F';
5599: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5600: fnd_message.set_token('VALUE',l_value);
5601: fnd_message.set_token('TABLE',l_table);
5602: fnd_msg_pub.add;