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_JP_IWHT_ARCH_PKG dependencies on PER_ADDRESSES

Line 967: , per_addresses PADR

963: ,DECODE(PADR.address_id,NULL,PADC.address_line3 ,PADR.address_line3) address_line3
964: FROM per_people_f PPF
965: , per_assignments_f PAF
966: , per_periods_of_service PPS
967: , per_addresses PADR
968: , per_addresses PADC
969: WHERE PAF.person_id = PPF.person_id
970: AND PPS.person_id = PPF.person_id
971: AND PAF.assignment_id = p_assignment_id

Line 968: , per_addresses PADC

964: FROM per_people_f PPF
965: , per_assignments_f PAF
966: , per_periods_of_service PPS
967: , per_addresses PADR
968: , per_addresses PADC
969: WHERE PAF.person_id = PPF.person_id
970: AND PPS.person_id = PPF.person_id
971: AND PAF.assignment_id = p_assignment_id
972: AND PADR.person_id(+) = PPF.person_id

Line 1024: FROM per_addresses PAD

1020: SELECT PAD.town_or_city jan_1st_district_code
1021: ,PAD.address_line1 jan_1st_address_line1
1022: ,PAD.address_line2 jan_1st_address_line2
1023: ,PAD.address_line3 jan_1st_address_line3
1024: FROM per_addresses PAD
1025: WHERE PAD.person_id = p_person_id
1026: AND ((PAD.address_type = 'JP_R')
1027: OR
1028: (PAD.address_type = 'JP_C'))

Line 1142: lc_1st_jan_district_code per_addresses.town_or_city%TYPE;

1138: lc_descfield2 pay_action_information.action_information23%TYPE;
1139: lc_descfield3 pay_action_information.action_information23%TYPE;
1140: lc_descfield4 pay_action_information.action_information24%TYPE;
1141: lc_descfield5 pay_action_information.action_information24%TYPE;
1142: lc_1st_jan_district_code per_addresses.town_or_city%TYPE;
1143: lc_1st_jan_address_line1 per_addresses.address_line1%TYPE;
1144: lc_1st_jan_address_line2 per_addresses.address_line2%TYPE;
1145: lc_1st_jan_address_line3 per_addresses.address_line3%TYPE;
1146: lc_note_submit_flag VARCHAR2(10);

Line 1143: lc_1st_jan_address_line1 per_addresses.address_line1%TYPE;

1139: lc_descfield3 pay_action_information.action_information23%TYPE;
1140: lc_descfield4 pay_action_information.action_information24%TYPE;
1141: lc_descfield5 pay_action_information.action_information24%TYPE;
1142: lc_1st_jan_district_code per_addresses.town_or_city%TYPE;
1143: lc_1st_jan_address_line1 per_addresses.address_line1%TYPE;
1144: lc_1st_jan_address_line2 per_addresses.address_line2%TYPE;
1145: lc_1st_jan_address_line3 per_addresses.address_line3%TYPE;
1146: lc_note_submit_flag VARCHAR2(10);
1147: lc_archive VARCHAR2(10) DEFAULT 'N';

Line 1144: lc_1st_jan_address_line2 per_addresses.address_line2%TYPE;

1140: lc_descfield4 pay_action_information.action_information24%TYPE;
1141: lc_descfield5 pay_action_information.action_information24%TYPE;
1142: lc_1st_jan_district_code per_addresses.town_or_city%TYPE;
1143: lc_1st_jan_address_line1 per_addresses.address_line1%TYPE;
1144: lc_1st_jan_address_line2 per_addresses.address_line2%TYPE;
1145: lc_1st_jan_address_line3 per_addresses.address_line3%TYPE;
1146: lc_note_submit_flag VARCHAR2(10);
1147: lc_archive VARCHAR2(10) DEFAULT 'N';
1148: lc_check_flag VARCHAR2(10) DEFAULT 'N';

Line 1145: lc_1st_jan_address_line3 per_addresses.address_line3%TYPE;

1141: lc_descfield5 pay_action_information.action_information24%TYPE;
1142: lc_1st_jan_district_code per_addresses.town_or_city%TYPE;
1143: lc_1st_jan_address_line1 per_addresses.address_line1%TYPE;
1144: lc_1st_jan_address_line2 per_addresses.address_line2%TYPE;
1145: lc_1st_jan_address_line3 per_addresses.address_line3%TYPE;
1146: lc_note_submit_flag VARCHAR2(10);
1147: lc_archive VARCHAR2(10) DEFAULT 'N';
1148: lc_check_flag VARCHAR2(10) DEFAULT 'N';
1149: l_allow_str VARCHAR2(60);