APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on BEN_EXT_CHG_EVT_LOG

Line 6728: FROM ben_ext_chg_evt_log

6724: CURSOR csr_chk_terminate_asg (c_assignment_id IN Number
6725: ,c_business_group_id IN Number
6726: ) IS
6727: SELECT chg_eff_dt
6728: FROM ben_ext_chg_evt_log
6729: WHERE person_id = g_person_id
6730: AND business_group_id = c_business_group_id
6731: AND chg_evt_cd = 'AAT'
6732: AND (chg_eff_dt BETWEEN g_extract_params (c_business_group_id).extract_start_date

Line 6909: FROM ben_ext_chg_evt_log

6905: --cursor to check for change in address.
6906: CURSOR csr_chk_chg_address(c_business_group_id IN Number
6907: ) IS
6908: SELECT chg_eff_dt
6909: FROM ben_ext_chg_evt_log
6910: WHERE person_id = g_person_id
6911: AND business_group_id = c_business_group_id
6912: AND (chg_evt_cd = 'COCN' ) --OR (chg_evt_cd = 'APA')
6913: AND ( chg_eff_dt between g_extract_params(c_business_group_id).extract_start_date

Line 6921: FROM ben_ext_chg_evt_log

6917: --cursor to check for change in foreign address.
6918: CURSOR csr_chk_chg_foreign_address(c_business_group_id IN Number
6919: ) IS
6920: SELECT chg_eff_dt
6921: FROM ben_ext_chg_evt_log
6922:
6923: WHERE person_id = g_person_id
6924: AND business_group_id = c_business_group_id
6925: AND ( chg_evt_cd = 'COPR' or

Line 6936: FROM ben_ext_chg_evt_log,

6932: CURSOR csr_chk_chg_COCN(c_business_group_id IN Number
6933: ,c_effective_date IN DATE
6934: ) IS
6935: SELECT hrl1.lookup_code
6936: FROM ben_ext_chg_evt_log,
6937: hr_lookups hrl1
6938: WHERE person_id = g_person_id
6939: AND business_group_id = c_business_group_id
6940: AND chg_evt_cd = 'COCN'

Line 6946: ( Select min(chg_eff_dt) FROM ben_ext_chg_evt_log

6942: AND hrl1.LOOKUP_TYPE='PQP_NL_STUCON_CODE_MAPPING'
6943: AND (chg_eff_dt between g_extract_params(c_business_group_id).extract_start_date
6944: AND g_extract_params(c_business_group_id).extract_start_date)
6945: AND chg_eff_dt >=
6946: ( Select min(chg_eff_dt) FROM ben_ext_chg_evt_log
6947: WHERE person_id = g_person_id
6948: AND business_group_id = c_business_group_id
6949: AND chg_evt_cd = 'COCN'
6950: AND chg_eff_dt >=c_effective_date

Line 6957: --the ben_ext_chg_evt_log table in case a change has been made

6953:
6954:
6955:
6956: --Cursor to fetch the old country code from
6957: --the ben_ext_chg_evt_log table in case a change has been made
6958: CURSOR c_get_old_cc( c_effective_date IN DATE) IS
6959: SELECT to_number(hrl1.lookup_code)
6960: FROM ben_ext_chg_evt_log,
6961: hr_lookups hrl1

Line 6960: FROM ben_ext_chg_evt_log,

6956: --Cursor to fetch the old country code from
6957: --the ben_ext_chg_evt_log table in case a change has been made
6958: CURSOR c_get_old_cc( c_effective_date IN DATE) IS
6959: SELECT to_number(hrl1.lookup_code)
6960: FROM ben_ext_chg_evt_log,
6961: hr_lookups hrl1
6962: WHERE chg_evt_cd = 'COCN'
6963: AND ( chg_eff_dt between g_extract_params(p_business_group_id).extract_start_date
6964: and g_extract_params(p_business_group_id).extract_end_date )

Line 6971: --the ben_ext_chg_evt_log table in case a change has been made

6967: AND person_id = g_person_id
6968: ORDER by ext_chg_evt_log_id desc;
6969:
6970: --Cursor to fetch the new country code from
6971: --the ben_ext_chg_evt_log table in case a change has been made
6972: CURSOR c_get_new_cc(c_effective_date IN DATE) IS
6973: SELECT to_number(hrl1.lookup_code)
6974: FROM ben_ext_chg_evt_log,
6975: hr_lookups hrl1

Line 6974: FROM ben_ext_chg_evt_log,

6970: --Cursor to fetch the new country code from
6971: --the ben_ext_chg_evt_log table in case a change has been made
6972: CURSOR c_get_new_cc(c_effective_date IN DATE) IS
6973: SELECT to_number(hrl1.lookup_code)
6974: FROM ben_ext_chg_evt_log,
6975: hr_lookups hrl1
6976: WHERE chg_evt_cd = 'COCN'
6977: AND ( chg_eff_dt between g_extract_params(p_business_group_id).extract_start_date
6978: and g_extract_params(p_business_group_id).extract_end_date )