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_24Q_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 5: ( person_id per_all_people_f.person_id%TYPE

1: PACKAGE BODY pay_in_24q_archive AS
2: /* $Header: pyin24qa.pkb 120.18.12010000.2 2008/08/06 07:25:44 ubhat ship $ */
3:
4: TYPE t_person_data_rec IS RECORD
5: ( person_id per_all_people_f.person_id%TYPE
6: ,pan_number per_all_people_f.per_information14%TYPE
7: ,pan_ref_number per_all_people_f.per_information14%TYPE
8: ,full_name per_all_people_f.full_name%TYPE
9: ,tax_rate per_assignment_extra_info.aei_information2 %TYPE

Line 6: ,pan_number per_all_people_f.per_information14%TYPE

2: /* $Header: pyin24qa.pkb 120.18.12010000.2 2008/08/06 07:25:44 ubhat ship $ */
3:
4: TYPE t_person_data_rec IS RECORD
5: ( person_id per_all_people_f.person_id%TYPE
6: ,pan_number per_all_people_f.per_information14%TYPE
7: ,pan_ref_number per_all_people_f.per_information14%TYPE
8: ,full_name per_all_people_f.full_name%TYPE
9: ,tax_rate per_assignment_extra_info.aei_information2 %TYPE
10: ,position per_all_positions.name%TYPE);

Line 7: ,pan_ref_number per_all_people_f.per_information14%TYPE

3:
4: TYPE t_person_data_rec IS RECORD
5: ( person_id per_all_people_f.person_id%TYPE
6: ,pan_number per_all_people_f.per_information14%TYPE
7: ,pan_ref_number per_all_people_f.per_information14%TYPE
8: ,full_name per_all_people_f.full_name%TYPE
9: ,tax_rate per_assignment_extra_info.aei_information2 %TYPE
10: ,position per_all_positions.name%TYPE);
11:

Line 8: ,full_name per_all_people_f.full_name%TYPE

4: TYPE t_person_data_rec IS RECORD
5: ( person_id per_all_people_f.person_id%TYPE
6: ,pan_number per_all_people_f.per_information14%TYPE
7: ,pan_ref_number per_all_people_f.per_information14%TYPE
8: ,full_name per_all_people_f.full_name%TYPE
9: ,tax_rate per_assignment_extra_info.aei_information2 %TYPE
10: ,position per_all_positions.name%TYPE);
11:
12: TYPE t_person_data_tab_type IS TABLE OF t_person_data_rec

Line 762: l_rep_person_id per_all_people_f.person_id%TYPE;

758: l_division hr_organization_information.org_information7%TYPE;
759: l_location_id hr_organization_units.location_id%TYPE;
760: l_pan hr_organization_information.org_information3%TYPE;
761: l_legal_name hr_organization_information.org_information4%TYPE;
762: l_rep_person_id per_all_people_f.person_id%TYPE;
763: l_rep_name per_all_people_f.full_name%TYPE;
764: l_position per_all_positions.name%TYPE;
765: l_rep_location hr_organization_units.location_id%TYPE;
766: l_rep_phone_no per_phones.phone_number%TYPE;

Line 763: l_rep_name per_all_people_f.full_name%TYPE;

759: l_location_id hr_organization_units.location_id%TYPE;
760: l_pan hr_organization_information.org_information3%TYPE;
761: l_legal_name hr_organization_information.org_information4%TYPE;
762: l_rep_person_id per_all_people_f.person_id%TYPE;
763: l_rep_name per_all_people_f.full_name%TYPE;
764: l_position per_all_positions.name%TYPE;
765: l_rep_location hr_organization_units.location_id%TYPE;
766: l_rep_phone_no per_phones.phone_number%TYPE;
767: l_rep_email_id per_all_people_f.email_address%TYPE;

Line 767: l_rep_email_id per_all_people_f.email_address%TYPE;

763: l_rep_name per_all_people_f.full_name%TYPE;
764: l_position per_all_positions.name%TYPE;
765: l_rep_location hr_organization_units.location_id%TYPE;
766: l_rep_phone_no per_phones.phone_number%TYPE;
767: l_rep_email_id per_all_people_f.email_address%TYPE;
768: l_action_info_id NUMBER;
769: l_ovn NUMBER;
770: l_challan_count NUMBER;
771: l_nil_challan VARCHAR2(1);

Line 953: l_person_id per_all_people_f.person_id%TYPE;

949: FROM per_all_assignments_f paf
950: WHERE paf.assignment_id =p_assignment_id
951: AND p_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
952:
953: l_person_id per_all_people_f.person_id%TYPE;
954: l_pan per_all_people_f.per_information4%TYPE;
955: l_pan_ref_num per_all_people_f.per_information14%TYPE;
956: l_name per_all_people_f.full_name%TYPE;
957: l_pos per_all_positions.name%TYPE;

Line 954: l_pan per_all_people_f.per_information4%TYPE;

950: WHERE paf.assignment_id =p_assignment_id
951: AND p_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
952:
953: l_person_id per_all_people_f.person_id%TYPE;
954: l_pan per_all_people_f.per_information4%TYPE;
955: l_pan_ref_num per_all_people_f.per_information14%TYPE;
956: l_name per_all_people_f.full_name%TYPE;
957: l_pos per_all_positions.name%TYPE;
958: l_tax_rate per_assignment_extra_info.aei_information2%TYPE;

Line 955: l_pan_ref_num per_all_people_f.per_information14%TYPE;

951: AND p_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
952:
953: l_person_id per_all_people_f.person_id%TYPE;
954: l_pan per_all_people_f.per_information4%TYPE;
955: l_pan_ref_num per_all_people_f.per_information14%TYPE;
956: l_name per_all_people_f.full_name%TYPE;
957: l_pos per_all_positions.name%TYPE;
958: l_tax_rate per_assignment_extra_info.aei_information2%TYPE;
959: l_action_info_id NUMBER;

Line 956: l_name per_all_people_f.full_name%TYPE;

952:
953: l_person_id per_all_people_f.person_id%TYPE;
954: l_pan per_all_people_f.per_information4%TYPE;
955: l_pan_ref_num per_all_people_f.per_information14%TYPE;
956: l_name per_all_people_f.full_name%TYPE;
957: l_pos per_all_positions.name%TYPE;
958: l_tax_rate per_assignment_extra_info.aei_information2%TYPE;
959: l_action_info_id NUMBER;
960: l_ovn NUMBER;

Line 962: l_full_name per_all_people_f.full_name%TYPE;

958: l_tax_rate per_assignment_extra_info.aei_information2%TYPE;
959: l_action_info_id NUMBER;
960: l_ovn NUMBER;
961: flag BOOLEAN;
962: l_full_name per_all_people_f.full_name%TYPE;
963:
964: l_effective_start_date DATE;
965: l_effective_end_date DATE;
966: l_payroll_id NUMBER;

Line 2269: l_full_name per_all_people_f.full_name%TYPE;

2265: l_ovn NUMBER;
2266: l_cnt NUMBER;
2267: i NUMBER;
2268: l_person_id NUMBER;
2269: l_full_name per_all_people_f.full_name%TYPE;
2270:
2271: l_pan per_all_people_f.per_information14%TYPE;
2272: l_pan_ref_num per_all_people_f.per_information14%TYPE;
2273: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;

Line 2271: l_pan per_all_people_f.per_information14%TYPE;

2267: i NUMBER;
2268: l_person_id NUMBER;
2269: l_full_name per_all_people_f.full_name%TYPE;
2270:
2271: l_pan per_all_people_f.per_information14%TYPE;
2272: l_pan_ref_num per_all_people_f.per_information14%TYPE;
2273: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
2274: l_pos per_all_positions.name%TYPE;
2275: l_proc VARCHAR2(100);

Line 2272: l_pan_ref_num per_all_people_f.per_information14%TYPE;

2268: l_person_id NUMBER;
2269: l_full_name per_all_people_f.full_name%TYPE;
2270:
2271: l_pan per_all_people_f.per_information14%TYPE;
2272: l_pan_ref_num per_all_people_f.per_information14%TYPE;
2273: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
2274: l_pos per_all_positions.name%TYPE;
2275: l_proc VARCHAR2(100);
2276: l_message VARCHAR2(255);