DBA Data[Home] [Help]

APPS.PQP_PENSION_TYPES_API dependencies on PAY_ELEMENT_TYPES_F

Line 1184: l_balance_init_element_type_id pay_element_types_f.element_type_id%TYPE;

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;
1186: l_effective_end_date date;
1187: l_api_warning varchar2(250);
1188: l_sum_percent number(7,4);

Line 2422: From pay_element_types_f

2418: -- Cursor to retrieve element ovn
2419: Cursor csr_get_ele_ovn
2420: Is
2421: Select object_version_number
2422: From pay_element_types_f
2423: Where element_type_id = p_balance_init_ele_type_id
2424: And p_effective_date Between effective_start_date
2425: And effective_end_date;
2426: