APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on HR_API

Line 1955: AND Nvl(date_to,Hr_Api.g_eot)

1951: hr_organization_information hoi
1952: WHERE hoi.organization_id = p_business_group_id
1953: AND To_Number(hoi.org_information1) = pos.organization_structure_id
1954: AND Trunc(p_effective_date) BETWEEN date_from
1955: AND Nvl(date_to,Hr_Api.g_eot)
1956: AND hoi.org_information_context = 'NL_BG_INFO';
1957:
1958: -- Cursor to get the list of child orgs from the hierarchy if one exists.
1959: CURSOR c_get_children ( c_org_str_ver_id IN Number

Line 2285: l_date date := hr_api.g_eot;

2281: l_def_bal_id number;
2282: l_amount number;
2283: l_context_id number;
2284: l_code number;
2285: l_date date := hr_api.g_eot;
2286: l_ptp_start_date DATE;
2287: l_new_start date;
2288: l_old_start date;
2289: l_tax_org_flag varchar2(1);

Line 2834: AND Nvl(date_to,Hr_Api.g_eot)

2830: SELECT region_1
2831: FROM per_addresses_v
2832: WHERE person_id = c_person_id
2833: AND p_effective_date BETWEEN date_from
2834: AND Nvl(date_to,Hr_Api.g_eot)
2835: AND primary_flag = 'Y'
2836: AND style = 'NL'
2837: UNION
2838: SELECT address_line1

Line 2842: AND Nvl(date_to,Hr_Api.g_eot)

2838: SELECT address_line1
2839: FROM per_addresses_v
2840: WHERE person_id = c_person_id
2841: AND p_effective_date BETWEEN date_from
2842: AND Nvl(date_to,Hr_Api.g_eot)
2843: AND primary_flag = 'Y'
2844: AND style = 'NL_GLB';
2845:
2846: l_street per_addresses_v.region_1%TYPE;

Line 2884: AND Nvl(date_to,Hr_Api.g_eot)

2880: SELECT add_information13
2881: FROM per_addresses_v
2882: WHERE person_id = c_person_id
2883: AND p_effective_date BETWEEN date_from
2884: AND Nvl(date_to,Hr_Api.g_eot)
2885: AND style = 'NL'
2886: AND primary_flag = 'Y'
2887: UNION
2888: SELECT address_line2

Line 2892: AND Nvl(date_to,Hr_Api.g_eot)

2888: SELECT address_line2
2889: FROM per_addresses_v
2890: WHERE person_id = c_person_id
2891: AND p_effective_date BETWEEN date_from
2892: AND Nvl(date_to,Hr_Api.g_eot)
2893: AND style = 'NL_GLB'
2894: AND primary_flag = 'Y';
2895:
2896:

Line 2935: AND Nvl(date_to,Hr_Api.g_eot)

2931: SELECT add_information14
2932: FROM per_addresses_v
2933: WHERE person_id = c_person_id
2934: AND p_effective_date BETWEEN date_from
2935: AND Nvl(date_to,Hr_Api.g_eot)
2936: AND primary_flag = 'Y'
2937: AND style = 'NL'
2938: UNION
2939: SELECT address_line3

Line 2943: AND Nvl(date_to,Hr_Api.g_eot)

2939: SELECT address_line3
2940: FROM per_addresses_v
2941: WHERE person_id = c_person_id
2942: AND p_effective_date BETWEEN date_from
2943: AND Nvl(date_to,Hr_Api.g_eot)
2944: AND primary_flag = 'Y'
2945: AND style = 'NL_GLB';
2946:
2947: l_addl_house_num per_addresses_v.address_line1%TYPE;

Line 2988: AND Nvl(date_to,Hr_Api.g_eot)

2984: SELECT postal_code
2985: FROM per_addresses_v
2986: WHERE person_id = c_person_id
2987: AND p_effective_date BETWEEN date_from
2988: AND Nvl(date_to,Hr_Api.g_eot)
2989: AND style IN ('NL','NL_GLB')
2990: AND primary_flag = 'Y';
2991:
2992: l_postal_code per_addresses_v.postal_code%TYPE;

Line 3045: AND Nvl(date_to,Hr_Api.g_eot)

3041: SELECT town_or_city
3042: FROM per_addresses_v
3043: WHERE person_id = c_person_id
3044: AND p_effective_date BETWEEN date_from
3045: AND Nvl(date_to,Hr_Api.g_eot)
3046: AND style IN ('NL','NL_GLB')
3047: AND primary_flag = 'Y';
3048:
3049: CURSOR cur_get_foreign_coun(c_person_id IN Number) IS

Line 3055: AND Nvl(date_to,Hr_Api.g_eot)

3051: ,d_country
3052: FROM per_addresses_v
3053: WHERE person_id = c_person_id
3054: AND p_effective_date BETWEEN date_from
3055: AND Nvl(date_to,Hr_Api.g_eot)
3056: AND style IN ('NL','NL_GLB')
3057: AND primary_flag = 'Y';
3058:
3059: