APPS.PQP_PENSION_TYPES_API dependencies on PQP_PENSION_TYPES_F

Line 1112: FROM pqp_pension_types_f

1108:
1109: -- Cursor to check if the pension type already exists
1110: CURSOR csr_pension_type IS
1111: SELECT 'x'
1112: FROM pqp_pension_types_f
1113: WHERE pension_type_name = p_pension_type_name_in
1114: AND business_group_id = p_bg_id
1115: AND rownum = 1;
1116:

Line 1249: l_pension_type_id pqp_pension_types_f.pension_type_id%TYPE;

1245: WHERE business_group_id = p_business_group_id;
1246:
1247: l_proc varchar2(150) := g_package||'Create_Pension_Type';
1248: l_effective_date date;
1249: l_pension_type_id pqp_pension_types_f.pension_type_id%TYPE;
1250: l_object_version_number pqp_pension_types_f.object_version_number%TYPE;
1251: l_ee_contribution_bal_type_id pay_balance_types.balance_type_id%TYPE;
1252: l_er_contribution_bal_type_id pay_balance_types.balance_type_id%TYPE;
1253: l_balance_init_element_type_id pay_element_types_f.element_type_id%TYPE;

Line 1250: l_object_version_number pqp_pension_types_f.object_version_number%TYPE;

1246:
1247: l_proc varchar2(150) := g_package||'Create_Pension_Type';
1248: l_effective_date date;
1249: l_pension_type_id pqp_pension_types_f.pension_type_id%TYPE;
1250: l_object_version_number pqp_pension_types_f.object_version_number%TYPE;
1251: l_ee_contribution_bal_type_id pay_balance_types.balance_type_id%TYPE;
1252: l_er_contribution_bal_type_id pay_balance_types.balance_type_id%TYPE;
1253: l_balance_init_element_type_id pay_element_types_f.element_type_id%TYPE;
1254: l_effective_start_date date;

Line 1929: l_object_version_number pqp_pension_types_f.object_version_number%TYPE;

1925: ,p_effective_end_date out nocopy date
1926: ,p_api_warning out nocopy varchar2
1927: ) Is
1928: l_proc varchar2(150) := g_package||'Update_Pension_Type';
1929: l_object_version_number pqp_pension_types_f.object_version_number%TYPE;
1930: l_effective_date date;
1931: l_effective_start_date date;
1932: l_effective_end_date date;
1933: l_sum_percent number(7,4);

Line 1951: FROM pqp_pension_types_f

1947: AND eei_information3 = fnd_number.number_to_canonical(p_pension_type_id);
1948:
1949: CURSOR c_get_category IS
1950: SELECT pension_category
1951: FROM pqp_pension_types_f
1952: WHERE pension_type_id = p_pension_type_id
1953: AND p_effective_date BETWEEN effective_start_date
1954: AND effective_end_date;
1955:

Line 2433: From pqp_pension_types_f

2429: Is
2430: Select ee_contribution_bal_type_id
2431: ,er_contribution_bal_type_id
2432: ,balance_init_element_type_id
2433: From pqp_pension_types_f
2434: Where pension_type_id = p_pension_type_id
2435: And p_effective_date Between effective_start_date
2436: And effective_end_date;
2437:

Line 2637: p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE

2633: --|--------------------------------------------------|
2634: -- ---------------------------------------------------------------------
2635: --
2636: PROCEDURE end_date_org_info (
2637: p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
2638: ,p_effective_end_date in date
2639: ) IS
2640:
2641: CURSOR c_get_org_info IS

Line 2739: l_object_version_number pqp_pension_types_f.object_version_number%TYPE;

2735: ,p_api_warning out nocopy varchar2
2736: )Is
2737:
2738: l_proc varchar2(150) := g_package||'Delete_Pension_Type';
2739: l_object_version_number pqp_pension_types_f.object_version_number%TYPE;
2740: l_effective_date date;
2741: l_effective_start_date date;
2742: l_effective_end_date date;
2743: l_ee_contribution_bal_type_id number;

Line 2751: FROM pqp_pension_types_f

2747:
2748: --Cursor to check that the pension type is a ABP Pension Type
2749: CURSOR c_chk_abp_pt IS
2750: SELECT 1
2751: FROM pqp_pension_types_f
2752: WHERE pension_type_id = p_pension_type_id
2753: AND special_pension_type_code = 'ABP';
2754:
2755: Begin