DBA Data[Home] [Help]

APPS.PQP_PENSION_TYPES_API dependencies on PAY_ELEMENT_TYPES_F

Line 1253: l_balance_init_element_type_id pay_element_types_f.element_type_id%TYPE;

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;
1255: l_effective_end_date date;
1256: l_api_warning varchar2(250);
1257: l_sum_percent number(7,4);

Line 2495: From pay_element_types_f

2491: -- Cursor to retrieve element ovn
2492: Cursor csr_get_ele_ovn
2493: Is
2494: Select object_version_number
2495: From pay_element_types_f
2496: Where element_type_id = p_balance_init_ele_type_id
2497: And p_effective_date Between effective_start_date
2498: And effective_end_date;
2499: