APPS.PAY_NL_PAYFILE dependencies on PER_ADDRESSES

Line 459: FROM per_addresses pas

455: ,p_effective_date IN DATE) RETURN VARCHAR2 AS
456: --
457: CURSOR csr_get_per_address_style(p_payee_id NUMBER) IS -- to get the address style
458: SELECT substr(style,1,35) style
459: FROM per_addresses pas
460: WHERE pas.person_id = p_payee_id
461: AND pas.primary_flag = 'Y'
462: AND p_effective_date BETWEEN pas.date_from
463: AND nvl(pas.date_to,to_date('31/12/4712','DD/MM/YYYY'));

Line 467: FROM per_addresses pas

463: AND nvl(pas.date_to,to_date('31/12/4712','DD/MM/YYYY'));
464: --
465: CURSOR csr_get_per_address(p_payee_id NUMBER) IS -- to get the city when address style is Netherlands
466: SELECT substr(hr_general.decode_lookup('HR_NL_CITY',town_or_city),1,35) town_or_city
467: FROM per_addresses pas
468: WHERE pas.person_id = p_payee_id
469: AND pas.primary_flag = 'Y'
470: AND p_effective_date BETWEEN pas.date_from
471: AND nvl(pas.date_to,to_date('31/12/4712','DD/MM/YYYY'));

Line 475: FROM per_addresses pas

471: AND nvl(pas.date_to,to_date('31/12/4712','DD/MM/YYYY'));
472: --
473: CURSOR csr_get_per_address1(p_payee_id NUMBER) IS -- to get the city when address style is Netherlands (International)
474: SELECT substr(town_or_city,1,35) town_or_city
475: FROM per_addresses pas
476: WHERE pas.person_id = p_payee_id
477: AND pas.primary_flag = 'Y'
478: AND p_effective_date BETWEEN pas.date_from
479: AND nvl(pas.date_to,to_date('31/12/4712','DD/MM/YYYY'));