APPS.PQP_PENSION_TYPES_API dependencies on PQP_PENSION_TYPES_F

Line 1043: FROM pqp_pension_types_f

1039:
1040: -- Cursor to check if the pension type already exists
1041: CURSOR csr_pension_type IS
1042: SELECT 'x'
1043: FROM pqp_pension_types_f
1044: WHERE pension_type_name = p_pension_type_name_in
1045: AND business_group_id = p_bg_id
1046: AND rownum = 1;
1047:

Line 1180: l_pension_type_id pqp_pension_types_f.pension_type_id%TYPE;

1176: WHERE business_group_id = p_business_group_id;
1177:
1178: l_proc varchar2(150) := g_package||'Create_Pension_Type';
1179: l_effective_date date;
1180: l_pension_type_id pqp_pension_types_f.pension_type_id%TYPE;
1181: l_object_version_number pqp_pension_types_f.object_version_number%TYPE;
1182: l_ee_contribution_bal_type_id pay_balance_types.balance_type_id%TYPE;
1183: l_er_contribution_bal_type_id pay_balance_types.balance_type_id%TYPE;
1184: l_balance_init_element_type_id pay_element_types_f.element_type_id%TYPE;

Line 1181: l_object_version_number pqp_pension_types_f.object_version_number%TYPE;

1177:
1178: l_proc varchar2(150) := g_package||'Create_Pension_Type';
1179: l_effective_date date;
1180: l_pension_type_id pqp_pension_types_f.pension_type_id%TYPE;
1181: l_object_version_number pqp_pension_types_f.object_version_number%TYPE;
1182: l_ee_contribution_bal_type_id pay_balance_types.balance_type_id%TYPE;
1183: l_er_contribution_bal_type_id pay_balance_types.balance_type_id%TYPE;
1184: l_balance_init_element_type_id pay_element_types_f.element_type_id%TYPE;
1185: l_effective_start_date date;

Line 1856: l_object_version_number pqp_pension_types_f.object_version_number%TYPE;

1852: ,p_effective_end_date out nocopy date
1853: ,p_api_warning out nocopy varchar2
1854: ) Is
1855: l_proc varchar2(150) := g_package||'Update_Pension_Type';
1856: l_object_version_number pqp_pension_types_f.object_version_number%TYPE;
1857: l_effective_date date;
1858: l_effective_start_date date;
1859: l_effective_end_date date;
1860: l_sum_percent number(7,4);

Line 1878: FROM pqp_pension_types_f

1874: AND eei_information3 = fnd_number.number_to_canonical(p_pension_type_id);
1875:
1876: CURSOR c_get_category IS
1877: SELECT pension_category
1878: FROM pqp_pension_types_f
1879: WHERE pension_type_id = p_pension_type_id
1880: AND p_effective_date BETWEEN effective_start_date
1881: AND effective_end_date;
1882:

Line 2360: From pqp_pension_types_f

2356: Is
2357: Select ee_contribution_bal_type_id
2358: ,er_contribution_bal_type_id
2359: ,balance_init_element_type_id
2360: From pqp_pension_types_f
2361: Where pension_type_id = p_pension_type_id
2362: And p_effective_date Between effective_start_date
2363: And effective_end_date;
2364:

Line 2564: p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE

2560: --|--------------------------------------------------|
2561: -- ---------------------------------------------------------------------
2562: --
2563: PROCEDURE end_date_org_info (
2564: p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
2565: ,p_effective_end_date in date
2566: ) IS
2567:
2568: CURSOR c_get_org_info IS

Line 2666: l_object_version_number pqp_pension_types_f.object_version_number%TYPE;

2662: ,p_api_warning out nocopy varchar2
2663: )Is
2664:
2665: l_proc varchar2(150) := g_package||'Delete_Pension_Type';
2666: l_object_version_number pqp_pension_types_f.object_version_number%TYPE;
2667: l_effective_date date;
2668: l_effective_start_date date;
2669: l_effective_end_date date;
2670: l_ee_contribution_bal_type_id number;

Line 2678: FROM pqp_pension_types_f

2674:
2675: --Cursor to check that the pension type is a ABP Pension Type
2676: CURSOR c_chk_abp_pt IS
2677: SELECT 1
2678: FROM pqp_pension_types_f
2679: WHERE pension_type_id = p_pension_type_id
2680: AND special_pension_type_code = 'ABP';
2681:
2682: Begin