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 2889: v_style per_addresses.style%type;

2885: p_person_id in per_all_people_f.person_id%type,
2886: p_basis_start in date,
2887: p_basis_end in date )
2888: is
2889: v_style per_addresses.style%type;
2890: v_address_type per_addresses.address_type%type;
2891: v_address_line_1 per_addresses.address_line1%type;
2892: v_address_line_2 per_addresses.address_line2%type;
2893: v_address_line_3 per_addresses.address_line3%type;

Line 2890: v_address_type per_addresses.address_type%type;

2886: p_basis_start in date,
2887: p_basis_end in date )
2888: is
2889: v_style per_addresses.style%type;
2890: v_address_type per_addresses.address_type%type;
2891: v_address_line_1 per_addresses.address_line1%type;
2892: v_address_line_2 per_addresses.address_line2%type;
2893: v_address_line_3 per_addresses.address_line3%type;
2894: v_postal_code per_addresses.postal_code%type;

Line 2891: v_address_line_1 per_addresses.address_line1%type;

2887: p_basis_end in date )
2888: is
2889: v_style per_addresses.style%type;
2890: v_address_type per_addresses.address_type%type;
2891: v_address_line_1 per_addresses.address_line1%type;
2892: v_address_line_2 per_addresses.address_line2%type;
2893: v_address_line_3 per_addresses.address_line3%type;
2894: v_postal_code per_addresses.postal_code%type;
2895: v_country per_addresses.country%type;

Line 2892: v_address_line_2 per_addresses.address_line2%type;

2888: is
2889: v_style per_addresses.style%type;
2890: v_address_type per_addresses.address_type%type;
2891: v_address_line_1 per_addresses.address_line1%type;
2892: v_address_line_2 per_addresses.address_line2%type;
2893: v_address_line_3 per_addresses.address_line3%type;
2894: v_postal_code per_addresses.postal_code%type;
2895: v_country per_addresses.country%type;
2896: v_country_code varchar2(3);

Line 2893: v_address_line_3 per_addresses.address_line3%type;

2889: v_style per_addresses.style%type;
2890: v_address_type per_addresses.address_type%type;
2891: v_address_line_1 per_addresses.address_line1%type;
2892: v_address_line_2 per_addresses.address_line2%type;
2893: v_address_line_3 per_addresses.address_line3%type;
2894: v_postal_code per_addresses.postal_code%type;
2895: v_country per_addresses.country%type;
2896: v_country_code varchar2(3);
2897: ---------------------------------------------------------------------------

Line 2894: v_postal_code per_addresses.postal_code%type;

2890: v_address_type per_addresses.address_type%type;
2891: v_address_line_1 per_addresses.address_line1%type;
2892: v_address_line_2 per_addresses.address_line2%type;
2893: v_address_line_3 per_addresses.address_line3%type;
2894: v_postal_code per_addresses.postal_code%type;
2895: v_country per_addresses.country%type;
2896: v_country_code varchar2(3);
2897: ---------------------------------------------------------------------------
2898: -- Padded postal code upto 6 chars, if null then store 999999*/

Line 2895: v_country per_addresses.country%type;

2891: v_address_line_1 per_addresses.address_line1%type;
2892: v_address_line_2 per_addresses.address_line2%type;
2893: v_address_line_3 per_addresses.address_line3%type;
2894: v_postal_code per_addresses.postal_code%type;
2895: v_country per_addresses.country%type;
2896: v_country_code varchar2(3);
2897: ---------------------------------------------------------------------------
2898: -- Padded postal code upto 6 chars, if null then store 999999*/
2899: -- Bug2647074

Line 2914: from per_addresses addr,

2910: addr.address_line3,
2911: addr.postal_code,
2912: -- lpad(nvl(addr.postal_code,'999999'),6,'0'),
2913: addr.country
2914: from per_addresses addr,
2915: fnd_territories_tl a
2916: where addr.person_id (+)= c_person_id
2917: and addr.primary_flag (+)= 'Y'
2918: and c_basis_end between nvl(addr.date_from, c_basis_start)

Line 2977: v_address_line_1 per_addresses.address_line1%type;

2973: p_person_id in per_all_people_f.person_id%type,
2974: p_basis_start in date,
2975: p_basis_end in date )
2976: is
2977: v_address_line_1 per_addresses.address_line1%type;
2978: v_address_line_2 per_addresses.address_line2%type;
2979: v_address_line_3 per_addresses.address_line3%type;
2980: v_postal_code per_addresses.postal_code%type;
2981: v_date_from varchar2(30);

Line 2978: v_address_line_2 per_addresses.address_line2%type;

2974: p_basis_start in date,
2975: p_basis_end in date )
2976: is
2977: v_address_line_1 per_addresses.address_line1%type;
2978: v_address_line_2 per_addresses.address_line2%type;
2979: v_address_line_3 per_addresses.address_line3%type;
2980: v_postal_code per_addresses.postal_code%type;
2981: v_date_from varchar2(30);
2982: v_date_to varchar2(30);

Line 2979: v_address_line_3 per_addresses.address_line3%type;

2975: p_basis_end in date )
2976: is
2977: v_address_line_1 per_addresses.address_line1%type;
2978: v_address_line_2 per_addresses.address_line2%type;
2979: v_address_line_3 per_addresses.address_line3%type;
2980: v_postal_code per_addresses.postal_code%type;
2981: v_date_from varchar2(30);
2982: v_date_to varchar2(30);
2983:

Line 2980: v_postal_code per_addresses.postal_code%type;

2976: is
2977: v_address_line_1 per_addresses.address_line1%type;
2978: v_address_line_2 per_addresses.address_line2%type;
2979: v_address_line_3 per_addresses.address_line3%type;
2980: v_postal_code per_addresses.postal_code%type;
2981: v_date_from varchar2(30);
2982: v_date_to varchar2(30);
2983:
2984: -- Added for bug 2373475

Line 2994: from per_addresses addr,

2990: addr.address_line2,
2991: addr.address_line3,
2992: fnd_date.date_to_canonical(addr.date_from),
2993: fnd_date.date_to_canonical(nvl(addr.date_to,c_basis_end))/* if its not blank, return the real end date, bug 2654499 */
2994: from per_addresses addr,
2995: fnd_territories_tl a
2996: where addr.person_id (+) = c_person_id
2997: and a.territory_code (+)= addr.country
2998: and a.language (+)= userenv('LANG')

Line 3004: from per_addresses

3000: and addr.country = 'SG'
3001: and addr.style <> 'SG'
3002: and nvl(addr.date_to, c_basis_end) =
3003: (select max(nvl(date_to, c_basis_end))
3004: from per_addresses
3005: where address_type = 'SG_CQ'
3006: and person_id = addr.person_id
3007: and (date_from <= c_basis_end
3008: and nvl(date_to, c_basis_end) >= c_basis_start));/*Bug 2654499*/

Line 5136: ( c_country per_addresses.country%type)

5132:
5133: l_country_code varchar2(3);
5134:
5135: cursor country_code
5136: ( c_country per_addresses.country%type)
5137: is
5138: select meaning
5139: from hr_lookups
5140: where lookup_type = 'SG_COUNTRY_CODE'