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 981: FROM per_addresses pa

977: ,pa.address_line3 address_line_3
978: ,pa.postal_code postcode
979: ,decode(pa.style,'NO',substr(hr_general.decode_lookup('NO_POSTAL_CODE',pa.postal_code),
980: instr(hr_general.decode_lookup('NO_POSTAL_CODE',pa.postal_code),' ')+1),'NO_GLB',pa.town_or_city) postoffice
981: FROM per_addresses pa
982: WHERE pa.person_id = p_person_id
983: AND pa.primary_flag = 'Y'
984: AND pa.style IN ('NO', 'NO_GLB')
985: AND p_report_date BETWEEN pa.date_from

Line 1876: l_per_addr1 per_addresses.address_line1%TYPE;

1872: l_act_inf_id NUMBER;
1873: l_ovn NUMBER;
1874: l_bal_value NUMBER;
1875: l_seaman_status VARCHAR2(1) := 'N';
1876: l_per_addr1 per_addresses.address_line1%TYPE;
1877: l_per_addr2 per_addresses.address_line2%TYPE;
1878: l_per_addr3 per_addresses.address_line3%TYPE;
1879: l_per_postcode per_addresses.postal_code%TYPE;
1880: l_per_postoffice VARCHAR2(100);

Line 1877: l_per_addr2 per_addresses.address_line2%TYPE;

1873: l_ovn NUMBER;
1874: l_bal_value NUMBER;
1875: l_seaman_status VARCHAR2(1) := 'N';
1876: l_per_addr1 per_addresses.address_line1%TYPE;
1877: l_per_addr2 per_addresses.address_line2%TYPE;
1878: l_per_addr3 per_addresses.address_line3%TYPE;
1879: l_per_postcode per_addresses.postal_code%TYPE;
1880: l_per_postoffice VARCHAR2(100);
1881: l_non_cont_dates_days VARCHAR2(20);

Line 1878: l_per_addr3 per_addresses.address_line3%TYPE;

1874: l_bal_value NUMBER;
1875: l_seaman_status VARCHAR2(1) := 'N';
1876: l_per_addr1 per_addresses.address_line1%TYPE;
1877: l_per_addr2 per_addresses.address_line2%TYPE;
1878: l_per_addr3 per_addresses.address_line3%TYPE;
1879: l_per_postcode per_addresses.postal_code%TYPE;
1880: l_per_postoffice VARCHAR2(100);
1881: l_non_cont_dates_days VARCHAR2(20);
1882: l_employed_throughout_year VARCHAR2(9);

Line 1879: l_per_postcode per_addresses.postal_code%TYPE;

1875: l_seaman_status VARCHAR2(1) := 'N';
1876: l_per_addr1 per_addresses.address_line1%TYPE;
1877: l_per_addr2 per_addresses.address_line2%TYPE;
1878: l_per_addr3 per_addresses.address_line3%TYPE;
1879: l_per_postcode per_addresses.postal_code%TYPE;
1880: l_per_postoffice VARCHAR2(100);
1881: l_non_cont_dates_days VARCHAR2(20);
1882: l_employed_throughout_year VARCHAR2(9);
1883: l_person_rec csr_PER%ROWTYPE;