APPS.PQP_NL_ABP_FUNCTIONS dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 527: FROM pay_element_type_extra_info

523: --Cursor to find the start and end dates of schemes created using the given PT
524: CURSOR cur_get_schm_st_end(c_pension_type_id IN varchar2) IS
525: SELECT to_date(substr(eei_information10,1,10),'DD/MM/YYYY') start_date,
526: to_date(substr(eei_information11,1,10),'DD/MM/YYYY') end_date
527: FROM pay_element_type_extra_info
528: WHERE eei_information_category = 'PQP_NL_ABP_DEDUCTION'
529: AND information_type = 'PQP_NL_ABP_DEDUCTION'
530: AND eei_information2 = c_pension_type_id;
531:

Line 1109: FROM pay_element_type_extra_info

1105: --Cursor to find the start and end dates of schemes created using the given PT
1106: CURSOR cur_get_schm_st_end(c_pension_type_id IN varchar2) IS
1107: SELECT to_date(substr(eei_information10,1,10),'DD/MM/YYYY') start_date,
1108: to_date(substr(eei_information11,1,10),'DD/MM/YYYY') end_date
1109: FROM pay_element_type_extra_info
1110: WHERE eei_information_category = 'PQP_NL_ABP_DEDUCTION'
1111: AND information_type = 'PQP_NL_ABP_DEDUCTION'
1112: AND eei_information2 = c_pension_type_id;
1113:

Line 1129: FROM pay_element_type_extra_info

1125: (SELECT assignment_action_id
1126: FROM pay_run_results
1127: WHERE element_type_id IN
1128: (SELECT element_type_id
1129: FROM pay_element_type_extra_info
1130: WHERE information_type = 'PQP_NL_ABP_DEDUCTION'
1131: AND eei_information_category = 'PQP_NL_ABP_DEDUCTION'
1132: AND eei_information2 = p_org_information3_o
1133: )

Line 1918: FROM pay_element_type_extra_info

1914: --Cursor to find the start and end dates of schemes created using the given PT
1915: CURSOR cur_get_schm_st_end(c_pension_type_id IN varchar2) IS
1916: SELECT to_date(substr(eei_information10,1,10),'DD/MM/YYYY') start_date,
1917: to_date(substr(eei_information11,1,10),'DD/MM/YYYY') end_date
1918: FROM pay_element_type_extra_info
1919: WHERE eei_information_category = 'PQP_NL_ABP_DEDUCTION'
1920: AND information_type = 'PQP_NL_ABP_DEDUCTION'
1921: AND eei_information2 = c_pension_type_id;
1922:

Line 2876: FROM pay_element_type_extra_info

2872: --Cursor to find the start and end dates of schemes created using the given PT
2873: CURSOR cur_get_schm_st_end(c_pension_type_id IN varchar2) IS
2874: SELECT to_date(substr(eei_information10,1,10),'DD/MM/YYYY') start_date,
2875: to_date(substr(eei_information11,1,10),'DD/MM/YYYY') end_date
2876: FROM pay_element_type_extra_info
2877: WHERE eei_information_category = 'PQP_NL_ABP_DEDUCTION'
2878: AND information_type = 'PQP_NL_ABP_DEDUCTION'
2879: AND eei_information2 = c_pension_type_id;
2880:

Line 2904: FROM pay_element_type_extra_info

2900: (SELECT assignment_action_id
2901: FROM pay_run_results
2902: WHERE element_type_id IN
2903: (SELECT element_type_id
2904: FROM pay_element_type_extra_info
2905: WHERE information_type = 'PQP_NL_ABP_DEDUCTION'
2906: AND eei_information_category = 'PQP_NL_ABP_DEDUCTION'
2907: AND eei_information2 = p_aei_information3_o
2908: )

Line 4818: FROM pay_element_type_extra_info pete,

4814: -- it returns the valid pension type id for the scheme
4815: --
4816: CURSOR c_abp_schm IS
4817: SELECT fnd_number.canonical_to_number(eei_information2) pty_id
4818: FROM pay_element_type_extra_info pete,
4819: pay_element_types_f pet
4820: WHERE pete.information_type = 'PQP_NL_ABP_DEDUCTION'
4821: AND pete.element_type_id = pet.element_type_id
4822: AND p_date_earned BETWEEN pet.effective_start_date