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

Line 2837: v_style per_addresses.style%type;

2833: p_person_id in per_all_people_f.person_id%type,
2834: p_basis_start in date,
2835: p_basis_end in date )
2836: is
2837: v_style per_addresses.style%type;
2838: v_address_type per_addresses.address_type%type;
2839: v_address_line_1 per_addresses.address_line1%type;
2840: v_address_line_2 per_addresses.address_line2%type;
2841: v_address_line_3 per_addresses.address_line3%type;

Line 2838: v_address_type per_addresses.address_type%type;

2834: p_basis_start in date,
2835: p_basis_end in date )
2836: is
2837: v_style per_addresses.style%type;
2838: v_address_type per_addresses.address_type%type;
2839: v_address_line_1 per_addresses.address_line1%type;
2840: v_address_line_2 per_addresses.address_line2%type;
2841: v_address_line_3 per_addresses.address_line3%type;
2842: v_postal_code per_addresses.postal_code%type;

Line 2839: v_address_line_1 per_addresses.address_line1%type;

2835: p_basis_end in date )
2836: is
2837: v_style per_addresses.style%type;
2838: v_address_type per_addresses.address_type%type;
2839: v_address_line_1 per_addresses.address_line1%type;
2840: v_address_line_2 per_addresses.address_line2%type;
2841: v_address_line_3 per_addresses.address_line3%type;
2842: v_postal_code per_addresses.postal_code%type;
2843: v_country per_addresses.country%type;

Line 2840: v_address_line_2 per_addresses.address_line2%type;

2836: is
2837: v_style per_addresses.style%type;
2838: v_address_type per_addresses.address_type%type;
2839: v_address_line_1 per_addresses.address_line1%type;
2840: v_address_line_2 per_addresses.address_line2%type;
2841: v_address_line_3 per_addresses.address_line3%type;
2842: v_postal_code per_addresses.postal_code%type;
2843: v_country per_addresses.country%type;
2844: v_country_code varchar2(3);

Line 2841: v_address_line_3 per_addresses.address_line3%type;

2837: v_style per_addresses.style%type;
2838: v_address_type per_addresses.address_type%type;
2839: v_address_line_1 per_addresses.address_line1%type;
2840: v_address_line_2 per_addresses.address_line2%type;
2841: v_address_line_3 per_addresses.address_line3%type;
2842: v_postal_code per_addresses.postal_code%type;
2843: v_country per_addresses.country%type;
2844: v_country_code varchar2(3);
2845: ---------------------------------------------------------------------------

Line 2842: v_postal_code per_addresses.postal_code%type;

2838: v_address_type per_addresses.address_type%type;
2839: v_address_line_1 per_addresses.address_line1%type;
2840: v_address_line_2 per_addresses.address_line2%type;
2841: v_address_line_3 per_addresses.address_line3%type;
2842: v_postal_code per_addresses.postal_code%type;
2843: v_country per_addresses.country%type;
2844: v_country_code varchar2(3);
2845: ---------------------------------------------------------------------------
2846: -- Padded postal code upto 6 chars, if null then store 999999*/

Line 2843: v_country per_addresses.country%type;

2839: v_address_line_1 per_addresses.address_line1%type;
2840: v_address_line_2 per_addresses.address_line2%type;
2841: v_address_line_3 per_addresses.address_line3%type;
2842: v_postal_code per_addresses.postal_code%type;
2843: v_country per_addresses.country%type;
2844: v_country_code varchar2(3);
2845: ---------------------------------------------------------------------------
2846: -- Padded postal code upto 6 chars, if null then store 999999*/
2847: -- Bug2647074

Line 2861: from per_addresses addr,

2857: addr.address_line2,
2858: addr.address_line3,
2859: lpad(nvl(addr.postal_code,'999999'),6,'0'),
2860: addr.country
2861: from per_addresses addr,
2862: fnd_territories_tl a
2863: where addr.person_id (+)= c_person_id
2864: and addr.primary_flag (+)= 'Y'
2865: and c_basis_end between nvl(addr.date_from, c_basis_start)

Line 2922: v_address_line_1 per_addresses.address_line1%type;

2918: p_person_id in per_all_people_f.person_id%type,
2919: p_basis_start in date,
2920: p_basis_end in date )
2921: is
2922: v_address_line_1 per_addresses.address_line1%type;
2923: v_address_line_2 per_addresses.address_line2%type;
2924: v_address_line_3 per_addresses.address_line3%type;
2925: v_date_from varchar2(30);
2926: v_date_to varchar2(30);

Line 2923: v_address_line_2 per_addresses.address_line2%type;

2919: p_basis_start in date,
2920: p_basis_end in date )
2921: is
2922: v_address_line_1 per_addresses.address_line1%type;
2923: v_address_line_2 per_addresses.address_line2%type;
2924: v_address_line_3 per_addresses.address_line3%type;
2925: v_date_from varchar2(30);
2926: v_date_to varchar2(30);
2927:

Line 2924: v_address_line_3 per_addresses.address_line3%type;

2920: p_basis_end in date )
2921: is
2922: v_address_line_1 per_addresses.address_line1%type;
2923: v_address_line_2 per_addresses.address_line2%type;
2924: v_address_line_3 per_addresses.address_line3%type;
2925: v_date_from varchar2(30);
2926: v_date_to varchar2(30);
2927:
2928: -- Added for bug 2373475

Line 2938: from per_addresses addr,

2934: addr.address_line2,
2935: addr.address_line3,
2936: fnd_date.date_to_canonical(addr.date_from),
2937: fnd_date.date_to_canonical(nvl(addr.date_to,c_basis_end))/* if its not blank, return the real end date, bug 2654499 */
2938: from per_addresses addr,
2939: fnd_territories_tl a
2940: where addr.person_id (+) = c_person_id
2941: and a.territory_code (+)= addr.country
2942: and a.language (+)= userenv('LANG')

Line 2946: from per_addresses

2942: and a.language (+)= userenv('LANG')
2943: and addr.address_type = 'SG_CQ' -- SG specific Company Quarters Address Type
2944: and nvl(addr.date_to, c_basis_end) =
2945: (select max(nvl(date_to, c_basis_end))
2946: from per_addresses
2947: where address_type = 'SG_CQ'
2948: and person_id = addr.person_id
2949: and (date_from <= c_basis_end
2950: and nvl(date_to, c_basis_end) >= c_basis_start));/*Bug 2654499*/

Line 4881: ( c_country per_addresses.country%type)

4877:
4878: l_country_code varchar2(3);
4879:
4880: cursor country_code
4881: ( c_country per_addresses.country%type)
4882: is
4883: select meaning
4884: from hr_lookups
4885: where lookup_type = 'SG_COUNTRY_CODE'