APPS.PQP_NL_EXT_FUNCTIONS dependencies on PQP_PENSION_TYPES_F

Line 8: FROM pqp_pension_types_f

4:
5: --cursor to fetch the subcategory for the pension type
6: CURSOR c_get_subcat(c_pt IN varchar2) IS
7: SELECT distinct(pension_sub_category)
8: FROM pqp_pension_types_f
9: WHERE pension_type_id = fnd_number.canonical_to_number(c_pt);
10:
11: --cursor to check the enabled flag for the lookup code before logging changes
12: CURSOR chk_if_enabled(c_code IN VARCHAR2) IS

Line 34: l_sub_cat pqp_pension_types_f.pension_sub_category%TYPE;

30:
31: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
32: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
33: l_business_group_id ben_ext_chg_evt_log.business_group_id%TYPE;
34: l_sub_cat pqp_pension_types_f.pension_sub_category%TYPE;
35: l_enabled varchar2(1) := 'N';
36:
37: CURSOR c_get_bgid IS
38: SELECT business_group_id

Line 126: l_sub_cat pqp_pension_types_f.pension_sub_category%TYPE;

122: l_prmtr2 ben_ext_chg_evt_log.prmtr_02%TYPE;
123: l_prmtr4 ben_ext_chg_evt_log.prmtr_04%TYPE;
124: l_prmtr5 ben_ext_chg_evt_log.prmtr_05%TYPE;
125: l_bgid ben_ext_chg_evt_log.business_group_id%TYPE;
126: l_sub_cat pqp_pension_types_f.pension_sub_category%TYPE;
127: l_enabled varchar2(1) := 'N';
128:
129: BEGIN
130:

Line 330: l_sub_cat pqp_pension_types_f.pension_sub_category%TYPE;

326: l_person_id per_all_assignments_f.person_id%TYPE;
327: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
328: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
329: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
330: l_sub_cat pqp_pension_types_f.pension_sub_category%TYPE;
331: l_enabled VARCHAR2(1) := 'N';
332:
333: BEGIN
334:

Line 417: l_sub_cat pqp_pension_types_f.pension_sub_category%TYPE;

413:
414: l_person_id per_all_assignments_f.person_id%TYPE;
415: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
416: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
417: l_sub_cat pqp_pension_types_f.pension_sub_category%TYPE;
418: l_enabled VARCHAR2(1) := 'N';
419: l_log_xst_ovn NUMBER;
420: l_xst_log_id NUMBER;
421: l_xst_log_eff_dt DATE;