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 2931: l_rep_person_id per_all_people_f.person_id%TYPE;

2927: AND g_qr_end_date BETWEEN date_from AND NVL(date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
2928:
2929:
2930: l_reg_org_id hr_organization_information.org_information4%TYPE;
2931: l_rep_person_id per_all_people_f.person_id%TYPE;
2932: l_emplr_type hr_organization_information.org_information3%TYPE;
2933: l_emplr_type_24Q hr_organization_information.org_information6%TYPE;
2934: l_procedure VARCHAR2(250);
2935: l_message VARCHAR2(250);

Line 3214: l_rep_name per_all_people_f.full_name%TYPE;

3210: l_ministry_name hr_organization_information.org_information12%TYPE;
3211: l_other_ministry_name hr_organization_information.org_information13%TYPE;
3212: l_pao_reg_code hr_organization_information.org_information14%TYPE;
3213: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
3214: l_rep_name per_all_people_f.full_name%TYPE;
3215: l_rep_position per_all_positions.name%TYPE;
3216: l_rep_location hr_organization_units.location_id%TYPE;
3217: l_rep_email_id per_all_people_f.email_address%TYPE;
3218: l_rep_work_phone per_phones.phone_number%TYPE;

Line 3217: l_rep_email_id per_all_people_f.email_address%TYPE;

3213: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
3214: l_rep_name per_all_people_f.full_name%TYPE;
3215: l_rep_position per_all_positions.name%TYPE;
3216: l_rep_location hr_organization_units.location_id%TYPE;
3217: l_rep_email_id per_all_people_f.email_address%TYPE;
3218: l_rep_work_phone per_phones.phone_number%TYPE;
3219: l_rep_std_code per_phones.phone_number%TYPE;
3220: l_procedure VARCHAR2(250);
3221: l_message VARCHAR2(250);

Line 4234: l_person_id per_all_people_f.person_id%TYPE;

4230: AND assignment_end_date(paa.assignment_id) BETWEEN paa.effective_start_date AND paa.effective_end_date
4231: AND ROWNUM = 1;
4232:
4233:
4234: l_person_id per_all_people_f.person_id%TYPE;
4235: l_pan_number per_all_people_f.per_information14%TYPE;
4236: l_pan_ref_number per_all_people_f.per_information14%TYPE;
4237: l_full_name per_all_people_f.full_name%TYPE;
4238: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;

Line 4235: l_pan_number per_all_people_f.per_information14%TYPE;

4231: AND ROWNUM = 1;
4232:
4233:
4234: l_person_id per_all_people_f.person_id%TYPE;
4235: l_pan_number per_all_people_f.per_information14%TYPE;
4236: l_pan_ref_number per_all_people_f.per_information14%TYPE;
4237: l_full_name per_all_people_f.full_name%TYPE;
4238: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
4239: l_end_date DATE;

Line 4236: l_pan_ref_number per_all_people_f.per_information14%TYPE;

4232:
4233:
4234: l_person_id per_all_people_f.person_id%TYPE;
4235: l_pan_number per_all_people_f.per_information14%TYPE;
4236: l_pan_ref_number per_all_people_f.per_information14%TYPE;
4237: l_full_name per_all_people_f.full_name%TYPE;
4238: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
4239: l_end_date DATE;
4240: l_old_tax_rate per_assignment_extra_info.aei_information2 %TYPE;

Line 4237: l_full_name per_all_people_f.full_name%TYPE;

4233:
4234: l_person_id per_all_people_f.person_id%TYPE;
4235: l_pan_number per_all_people_f.per_information14%TYPE;
4236: l_pan_ref_number per_all_people_f.per_information14%TYPE;
4237: l_full_name per_all_people_f.full_name%TYPE;
4238: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
4239: l_end_date DATE;
4240: l_old_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
4241: l_action_information_id NUMBER;

Line 4770: l_per_id per_all_people_f.person_id%TYPE;

4766: BETWEEN asg.effective_start_date AND asg.effective_end_date
4767: ORDER BY 1 DESC;
4768:
4769:
4770: l_per_id per_all_people_f.person_id%TYPE;
4771: l_person_id per_all_people_f.person_id%TYPE;
4772: l_pan_number per_all_people_f.per_information14%TYPE;
4773: l_pan_ref_number per_all_people_f.per_information14%TYPE;
4774: l_full_name per_all_people_f.full_name%TYPE;

Line 4771: l_person_id per_all_people_f.person_id%TYPE;

4767: ORDER BY 1 DESC;
4768:
4769:
4770: l_per_id per_all_people_f.person_id%TYPE;
4771: l_person_id per_all_people_f.person_id%TYPE;
4772: l_pan_number per_all_people_f.per_information14%TYPE;
4773: l_pan_ref_number per_all_people_f.per_information14%TYPE;
4774: l_full_name per_all_people_f.full_name%TYPE;
4775:

Line 4772: l_pan_number per_all_people_f.per_information14%TYPE;

4768:
4769:
4770: l_per_id per_all_people_f.person_id%TYPE;
4771: l_person_id per_all_people_f.person_id%TYPE;
4772: l_pan_number per_all_people_f.per_information14%TYPE;
4773: l_pan_ref_number per_all_people_f.per_information14%TYPE;
4774: l_full_name per_all_people_f.full_name%TYPE;
4775:
4776: l_procedure VARCHAR2(250);

Line 4773: l_pan_ref_number per_all_people_f.per_information14%TYPE;

4769:
4770: l_per_id per_all_people_f.person_id%TYPE;
4771: l_person_id per_all_people_f.person_id%TYPE;
4772: l_pan_number per_all_people_f.per_information14%TYPE;
4773: l_pan_ref_number per_all_people_f.per_information14%TYPE;
4774: l_full_name per_all_people_f.full_name%TYPE;
4775:
4776: l_procedure VARCHAR2(250);
4777: l_message VARCHAR2(250);

Line 4774: l_full_name per_all_people_f.full_name%TYPE;

4770: l_per_id per_all_people_f.person_id%TYPE;
4771: l_person_id per_all_people_f.person_id%TYPE;
4772: l_pan_number per_all_people_f.per_information14%TYPE;
4773: l_pan_ref_number per_all_people_f.per_information14%TYPE;
4774: l_full_name per_all_people_f.full_name%TYPE;
4775:
4776: l_procedure VARCHAR2(250);
4777: l_message VARCHAR2(250);
4778:

Line 7919: l_rep_name per_all_people_f.full_name%TYPE;

7915: l_ministry_name hr_organization_information.org_information12%TYPE;
7916: l_other_ministry_name hr_organization_information.org_information13%TYPE;
7917: l_pao_reg_code hr_organization_information.org_information14%TYPE;
7918: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
7919: l_rep_name per_all_people_f.full_name%TYPE;
7920: l_rep_position per_all_positions.name%TYPE;
7921: l_rep_location hr_organization_units.location_id%TYPE;
7922: l_rep_email_id per_all_people_f.email_address%TYPE;
7923: l_rep_work_phone per_phones.phone_number%TYPE;

Line 7922: l_rep_email_id per_all_people_f.email_address%TYPE;

7918: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
7919: l_rep_name per_all_people_f.full_name%TYPE;
7920: l_rep_position per_all_positions.name%TYPE;
7921: l_rep_location hr_organization_units.location_id%TYPE;
7922: l_rep_email_id per_all_people_f.email_address%TYPE;
7923: l_rep_work_phone per_phones.phone_number%TYPE;
7924: l_rep_std_code per_phones.phone_number%TYPE;
7925:
7926: l_action_info_id NUMBER;

Line 8478: l_rep_name per_all_people_f.full_name%TYPE;

8474: l_ministry_name hr_organization_information.org_information12%TYPE;
8475: l_other_ministry_name hr_organization_information.org_information13%TYPE;
8476: l_pao_reg_code hr_organization_information.org_information14%TYPE;
8477: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
8478: l_rep_name per_all_people_f.full_name%TYPE;
8479: l_rep_position per_all_positions.name%TYPE;
8480: l_rep_location hr_organization_units.location_id%TYPE;
8481: l_rep_email_id per_all_people_f.email_address%TYPE;
8482: l_rep_work_phone per_phones.phone_number%TYPE;

Line 8481: l_rep_email_id per_all_people_f.email_address%TYPE;

8477: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
8478: l_rep_name per_all_people_f.full_name%TYPE;
8479: l_rep_position per_all_positions.name%TYPE;
8480: l_rep_location hr_organization_units.location_id%TYPE;
8481: l_rep_email_id per_all_people_f.email_address%TYPE;
8482: l_rep_work_phone per_phones.phone_number%TYPE;
8483: l_rep_std_code per_phones.phone_number%TYPE;
8484: l_flag_number NUMBER := -1;
8485: l_action_info_id NUMBER;