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.26.12020000.3 2013/02/06 09:52:09 pthummal 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.26.12020000.3 2013/02/06 09:52:09 pthummal 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 807: l_rep_person_id per_all_people_f.person_id%TYPE;

803: l_ministry_name hr_organization_information.org_information12%TYPE;
804: l_other_ministry_name hr_organization_information.org_information13%TYPE;
805: l_pao_reg_code hr_organization_information.org_information14%TYPE;
806: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
807: l_rep_person_id per_all_people_f.person_id%TYPE;
808: l_rep_name per_all_people_f.full_name%TYPE;
809: l_position per_all_positions.name%TYPE;
810: l_rep_location hr_organization_units.location_id%TYPE;
811: l_rep_phone_no per_phones.phone_number%TYPE;

Line 808: l_rep_name per_all_people_f.full_name%TYPE;

804: l_other_ministry_name hr_organization_information.org_information13%TYPE;
805: l_pao_reg_code hr_organization_information.org_information14%TYPE;
806: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
807: l_rep_person_id per_all_people_f.person_id%TYPE;
808: l_rep_name per_all_people_f.full_name%TYPE;
809: l_position per_all_positions.name%TYPE;
810: l_rep_location hr_organization_units.location_id%TYPE;
811: l_rep_phone_no per_phones.phone_number%TYPE;
812: l_rep_mobile_no per_phones.phone_number%TYPE; -- Bug 12332524

Line 813: l_rep_email_id per_all_people_f.email_address%TYPE;

809: l_position per_all_positions.name%TYPE;
810: l_rep_location hr_organization_units.location_id%TYPE;
811: l_rep_phone_no per_phones.phone_number%TYPE;
812: l_rep_mobile_no per_phones.phone_number%TYPE; -- Bug 12332524
813: l_rep_email_id per_all_people_f.email_address%TYPE;
814: l_action_info_id NUMBER;
815: l_ovn NUMBER;
816: l_challan_count NUMBER;
817: l_nil_challan VARCHAR2(1);

Line 1034: l_person_id per_all_people_f.person_id%TYPE;

1030: FROM per_all_assignments_f paf
1031: WHERE paf.assignment_id =p_assignment_id
1032: AND p_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
1033:
1034: l_person_id per_all_people_f.person_id%TYPE;
1035: l_pan per_all_people_f.per_information4%TYPE;
1036: l_pan_ref_num per_all_people_f.per_information14%TYPE;
1037: l_name per_all_people_f.full_name%TYPE;
1038: l_pos per_all_positions.name%TYPE;

Line 1035: l_pan per_all_people_f.per_information4%TYPE;

1031: WHERE paf.assignment_id =p_assignment_id
1032: AND p_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
1033:
1034: l_person_id per_all_people_f.person_id%TYPE;
1035: l_pan per_all_people_f.per_information4%TYPE;
1036: l_pan_ref_num per_all_people_f.per_information14%TYPE;
1037: l_name per_all_people_f.full_name%TYPE;
1038: l_pos per_all_positions.name%TYPE;
1039: l_tax_rate per_assignment_extra_info.aei_information2%TYPE;

Line 1036: l_pan_ref_num per_all_people_f.per_information14%TYPE;

1032: AND p_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
1033:
1034: l_person_id per_all_people_f.person_id%TYPE;
1035: l_pan per_all_people_f.per_information4%TYPE;
1036: l_pan_ref_num per_all_people_f.per_information14%TYPE;
1037: l_name per_all_people_f.full_name%TYPE;
1038: l_pos per_all_positions.name%TYPE;
1039: l_tax_rate per_assignment_extra_info.aei_information2%TYPE;
1040: l_action_info_id NUMBER;

Line 1037: l_name per_all_people_f.full_name%TYPE;

1033:
1034: l_person_id per_all_people_f.person_id%TYPE;
1035: l_pan per_all_people_f.per_information4%TYPE;
1036: l_pan_ref_num per_all_people_f.per_information14%TYPE;
1037: l_name per_all_people_f.full_name%TYPE;
1038: l_pos per_all_positions.name%TYPE;
1039: l_tax_rate per_assignment_extra_info.aei_information2%TYPE;
1040: l_action_info_id NUMBER;
1041: l_ovn NUMBER;

Line 1043: l_full_name per_all_people_f.full_name%TYPE;

1039: l_tax_rate per_assignment_extra_info.aei_information2%TYPE;
1040: l_action_info_id NUMBER;
1041: l_ovn NUMBER;
1042: flag BOOLEAN;
1043: l_full_name per_all_people_f.full_name%TYPE;
1044:
1045: l_effective_start_date DATE;
1046: l_effective_end_date DATE;
1047: l_payroll_id NUMBER;

Line 2375: l_full_name per_all_people_f.full_name%TYPE;

2371: l_ovn NUMBER;
2372: l_cnt NUMBER;
2373: i NUMBER;
2374: l_person_id NUMBER;
2375: l_full_name per_all_people_f.full_name%TYPE;
2376:
2377: l_pan per_all_people_f.per_information14%TYPE;
2378: l_pan_ref_num per_all_people_f.per_information14%TYPE;
2379: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;

Line 2377: l_pan per_all_people_f.per_information14%TYPE;

2373: i NUMBER;
2374: l_person_id NUMBER;
2375: l_full_name per_all_people_f.full_name%TYPE;
2376:
2377: l_pan per_all_people_f.per_information14%TYPE;
2378: l_pan_ref_num per_all_people_f.per_information14%TYPE;
2379: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
2380: l_pos per_all_positions.name%TYPE;
2381: l_proc VARCHAR2(100);

Line 2378: l_pan_ref_num per_all_people_f.per_information14%TYPE;

2374: l_person_id NUMBER;
2375: l_full_name per_all_people_f.full_name%TYPE;
2376:
2377: l_pan per_all_people_f.per_information14%TYPE;
2378: l_pan_ref_num per_all_people_f.per_information14%TYPE;
2379: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
2380: l_pos per_all_positions.name%TYPE;
2381: l_proc VARCHAR2(100);
2382: l_message VARCHAR2(255);