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

Line 888: FROM per_addresses pa

884: ,pa.address_line3 address_line_3
885: ,pa.postal_code postcode
886: ,decode(pa.style,'NO',substr(hr_general.decode_lookup('NO_POSTAL_CODE',pa.postal_code),
887: instr(hr_general.decode_lookup('NO_POSTAL_CODE',pa.postal_code),' ')+1),'NO_GLB',pa.town_or_city) postoffice
888: FROM per_addresses pa
889: WHERE pa.person_id = p_person_id
890: AND pa.primary_flag = 'Y'
891: AND pa.style IN ('NO', 'NO_GLB')
892: AND p_report_date BETWEEN pa.date_from

Line 1694: l_per_addr1 per_addresses.address_line1%TYPE;

1690: l_act_inf_id NUMBER;
1691: l_ovn NUMBER;
1692: l_bal_value NUMBER;
1693: l_seaman_status VARCHAR2(1) := 'N';
1694: l_per_addr1 per_addresses.address_line1%TYPE;
1695: l_per_addr2 per_addresses.address_line2%TYPE;
1696: l_per_addr3 per_addresses.address_line3%TYPE;
1697: l_per_postcode per_addresses.postal_code%TYPE;
1698: l_per_postoffice VARCHAR2(100);

Line 1695: l_per_addr2 per_addresses.address_line2%TYPE;

1691: l_ovn NUMBER;
1692: l_bal_value NUMBER;
1693: l_seaman_status VARCHAR2(1) := 'N';
1694: l_per_addr1 per_addresses.address_line1%TYPE;
1695: l_per_addr2 per_addresses.address_line2%TYPE;
1696: l_per_addr3 per_addresses.address_line3%TYPE;
1697: l_per_postcode per_addresses.postal_code%TYPE;
1698: l_per_postoffice VARCHAR2(100);
1699: l_non_cont_dates_days VARCHAR2(20);

Line 1696: l_per_addr3 per_addresses.address_line3%TYPE;

1692: l_bal_value NUMBER;
1693: l_seaman_status VARCHAR2(1) := 'N';
1694: l_per_addr1 per_addresses.address_line1%TYPE;
1695: l_per_addr2 per_addresses.address_line2%TYPE;
1696: l_per_addr3 per_addresses.address_line3%TYPE;
1697: l_per_postcode per_addresses.postal_code%TYPE;
1698: l_per_postoffice VARCHAR2(100);
1699: l_non_cont_dates_days VARCHAR2(20);
1700: l_employed_throughout_year VARCHAR2(9);

Line 1697: l_per_postcode per_addresses.postal_code%TYPE;

1693: l_seaman_status VARCHAR2(1) := 'N';
1694: l_per_addr1 per_addresses.address_line1%TYPE;
1695: l_per_addr2 per_addresses.address_line2%TYPE;
1696: l_per_addr3 per_addresses.address_line3%TYPE;
1697: l_per_postcode per_addresses.postal_code%TYPE;
1698: l_per_postoffice VARCHAR2(100);
1699: l_non_cont_dates_days VARCHAR2(20);
1700: l_employed_throughout_year VARCHAR2(9);
1701: l_person_rec csr_PER%ROWTYPE;