eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_24QC_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 2809: l_rep_person_id per_all_people_f.person_id%TYPE;

2805: AND g_qr_end_date BETWEEN date_from AND NVL(date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
2806:
2807:
2808: l_reg_org_id hr_organization_information.org_information4%TYPE;
2809: l_rep_person_id per_all_people_f.person_id%TYPE;
2810: l_procedure VARCHAR2(250);
2811: l_message VARCHAR2(250);
2812: BEGIN
2813: g_debug := hr_utility.debug_enabled;

Line 2994: l_rep_name per_all_people_f.full_name%TYPE;

2990: l_branch_or_division hr_organization_information.org_information7%TYPE;
2991: l_org_location hr_organization_units.location_id%TYPE;
2992: l_pan_number hr_organization_information.org_information3%TYPE;
2993: l_legal_name hr_organization_information.org_information4%TYPE;
2994: l_rep_name per_all_people_f.full_name%TYPE;
2995: l_rep_position per_all_positions.name%TYPE;
2996: l_rep_location hr_organization_units.location_id%TYPE;
2997: l_rep_email_id per_all_people_f.email_address%TYPE;
2998: l_rep_work_phone per_phones.phone_number%TYPE;

Line 2997: l_rep_email_id per_all_people_f.email_address%TYPE;

2993: l_legal_name hr_organization_information.org_information4%TYPE;
2994: l_rep_name per_all_people_f.full_name%TYPE;
2995: l_rep_position per_all_positions.name%TYPE;
2996: l_rep_location hr_organization_units.location_id%TYPE;
2997: l_rep_email_id per_all_people_f.email_address%TYPE;
2998: l_rep_work_phone per_phones.phone_number%TYPE;
2999: l_rep_std_code per_phones.phone_number%TYPE;
3000: l_procedure VARCHAR2(250);
3001: l_message VARCHAR2(250);

Line 3910: l_person_id per_all_people_f.person_id%TYPE;

3906: AND assignment_end_date(paa.assignment_id) BETWEEN paa.effective_start_date AND paa.effective_end_date
3907: AND ROWNUM = 1;
3908:
3909:
3910: l_person_id per_all_people_f.person_id%TYPE;
3911: l_pan_number per_all_people_f.per_information14%TYPE;
3912: l_pan_ref_number per_all_people_f.per_information14%TYPE;
3913: l_full_name per_all_people_f.full_name%TYPE;
3914: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;

Line 3911: l_pan_number per_all_people_f.per_information14%TYPE;

3907: AND ROWNUM = 1;
3908:
3909:
3910: l_person_id per_all_people_f.person_id%TYPE;
3911: l_pan_number per_all_people_f.per_information14%TYPE;
3912: l_pan_ref_number per_all_people_f.per_information14%TYPE;
3913: l_full_name per_all_people_f.full_name%TYPE;
3914: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
3915: l_end_date DATE;

Line 3912: l_pan_ref_number per_all_people_f.per_information14%TYPE;

3908:
3909:
3910: l_person_id per_all_people_f.person_id%TYPE;
3911: l_pan_number per_all_people_f.per_information14%TYPE;
3912: l_pan_ref_number per_all_people_f.per_information14%TYPE;
3913: l_full_name per_all_people_f.full_name%TYPE;
3914: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
3915: l_end_date DATE;
3916: l_old_tax_rate per_assignment_extra_info.aei_information2 %TYPE;

Line 3913: l_full_name per_all_people_f.full_name%TYPE;

3909:
3910: l_person_id per_all_people_f.person_id%TYPE;
3911: l_pan_number per_all_people_f.per_information14%TYPE;
3912: l_pan_ref_number per_all_people_f.per_information14%TYPE;
3913: l_full_name per_all_people_f.full_name%TYPE;
3914: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
3915: l_end_date DATE;
3916: l_old_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
3917: l_action_information_id NUMBER;

Line 4446: l_per_id per_all_people_f.person_id%TYPE;

4442: BETWEEN asg.effective_start_date AND asg.effective_end_date
4443: ORDER BY 1 DESC;
4444:
4445:
4446: l_per_id per_all_people_f.person_id%TYPE;
4447: l_person_id per_all_people_f.person_id%TYPE;
4448: l_pan_number per_all_people_f.per_information14%TYPE;
4449: l_pan_ref_number per_all_people_f.per_information14%TYPE;
4450: l_full_name per_all_people_f.full_name%TYPE;

Line 4447: l_person_id per_all_people_f.person_id%TYPE;

4443: ORDER BY 1 DESC;
4444:
4445:
4446: l_per_id per_all_people_f.person_id%TYPE;
4447: l_person_id per_all_people_f.person_id%TYPE;
4448: l_pan_number per_all_people_f.per_information14%TYPE;
4449: l_pan_ref_number per_all_people_f.per_information14%TYPE;
4450: l_full_name per_all_people_f.full_name%TYPE;
4451:

Line 4448: l_pan_number per_all_people_f.per_information14%TYPE;

4444:
4445:
4446: l_per_id per_all_people_f.person_id%TYPE;
4447: l_person_id per_all_people_f.person_id%TYPE;
4448: l_pan_number per_all_people_f.per_information14%TYPE;
4449: l_pan_ref_number per_all_people_f.per_information14%TYPE;
4450: l_full_name per_all_people_f.full_name%TYPE;
4451:
4452: l_procedure VARCHAR2(250);

Line 4449: l_pan_ref_number per_all_people_f.per_information14%TYPE;

4445:
4446: l_per_id per_all_people_f.person_id%TYPE;
4447: l_person_id per_all_people_f.person_id%TYPE;
4448: l_pan_number per_all_people_f.per_information14%TYPE;
4449: l_pan_ref_number per_all_people_f.per_information14%TYPE;
4450: l_full_name per_all_people_f.full_name%TYPE;
4451:
4452: l_procedure VARCHAR2(250);
4453: l_message VARCHAR2(250);

Line 4450: l_full_name per_all_people_f.full_name%TYPE;

4446: l_per_id per_all_people_f.person_id%TYPE;
4447: l_person_id per_all_people_f.person_id%TYPE;
4448: l_pan_number per_all_people_f.per_information14%TYPE;
4449: l_pan_ref_number per_all_people_f.per_information14%TYPE;
4450: l_full_name per_all_people_f.full_name%TYPE;
4451:
4452: l_procedure VARCHAR2(250);
4453: l_message VARCHAR2(250);
4454:

Line 7570: l_rep_name per_all_people_f.full_name%TYPE;

7566: l_branch_or_division hr_organization_information.org_information7%TYPE;
7567: l_org_location hr_organization_units.location_id%TYPE;
7568: l_pan_number hr_organization_information.org_information3%TYPE;
7569: l_legal_name hr_organization_information.org_information4%TYPE;
7570: l_rep_name per_all_people_f.full_name%TYPE;
7571: l_rep_position per_all_positions.name%TYPE;
7572: l_rep_location hr_organization_units.location_id%TYPE;
7573: l_rep_email_id per_all_people_f.email_address%TYPE;
7574: l_rep_work_phone per_phones.phone_number%TYPE;

Line 7573: l_rep_email_id per_all_people_f.email_address%TYPE;

7569: l_legal_name hr_organization_information.org_information4%TYPE;
7570: l_rep_name per_all_people_f.full_name%TYPE;
7571: l_rep_position per_all_positions.name%TYPE;
7572: l_rep_location hr_organization_units.location_id%TYPE;
7573: l_rep_email_id per_all_people_f.email_address%TYPE;
7574: l_rep_work_phone per_phones.phone_number%TYPE;
7575: l_rep_std_code per_phones.phone_number%TYPE;
7576:
7577: l_action_info_id NUMBER;

Line 8089: l_rep_name per_all_people_f.full_name%TYPE;

8085: l_branch_or_division hr_organization_information.org_information7%TYPE;
8086: l_org_location hr_organization_units.location_id%TYPE;
8087: l_pan_number hr_organization_information.org_information3%TYPE;
8088: l_legal_name hr_organization_information.org_information4%TYPE;
8089: l_rep_name per_all_people_f.full_name%TYPE;
8090: l_rep_position per_all_positions.name%TYPE;
8091: l_rep_location hr_organization_units.location_id%TYPE;
8092: l_rep_email_id per_all_people_f.email_address%TYPE;
8093: l_rep_work_phone per_phones.phone_number%TYPE;

Line 8092: l_rep_email_id per_all_people_f.email_address%TYPE;

8088: l_legal_name hr_organization_information.org_information4%TYPE;
8089: l_rep_name per_all_people_f.full_name%TYPE;
8090: l_rep_position per_all_positions.name%TYPE;
8091: l_rep_location hr_organization_units.location_id%TYPE;
8092: l_rep_email_id per_all_people_f.email_address%TYPE;
8093: l_rep_work_phone per_phones.phone_number%TYPE;
8094: l_rep_std_code per_phones.phone_number%TYPE;
8095: l_flag_number NUMBER := -1;
8096: l_action_info_id NUMBER;