APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 484: ,p_rec_eeit_info OUT NOCOPY pay_element_type_extra_info%ROWTYPE

480: -- ----------------------------------------------------------------------------
481: PROCEDURE get_eeit_info(
482: p_element_type_id IN NUMBER
483: ,p_information_type IN VARCHAR2
484: ,p_rec_eeit_info OUT NOCOPY pay_element_type_extra_info%ROWTYPE
485: )
486: IS
487: --
488: -- Cursor to get eei information

Line 492: FROM pay_element_type_extra_info

488: -- Cursor to get eei information
489: CURSOR csr_get_eei_info
490: IS
491: SELECT *
492: FROM pay_element_type_extra_info
493: WHERE element_type_id = p_element_type_id
494: AND information_type = p_information_type;
495:
496: l_proc_name VARCHAR2(80) := g_proc_name || 'get_eeit_info';

Line 498: l_rec_eeit_info pay_element_type_extra_info%ROWTYPE;

494: AND information_type = p_information_type;
495:
496: l_proc_name VARCHAR2(80) := g_proc_name || 'get_eeit_info';
497: l_proc_step PLS_INTEGER;
498: l_rec_eeit_info pay_element_type_extra_info%ROWTYPE;
499: --
500: BEGIN
501: --
502: IF g_debug

Line 2322: FROM pay_element_type_extra_info

2318: -- Cursor to fetch eei information
2319: CURSOR csr_get_avc_eei_info
2320: IS
2321: SELECT *
2322: FROM pay_element_type_extra_info
2323: WHERE information_type = p_information_type
2324: AND eei_information16 = p_associated_ocp_ele_id
2325: AND eei_information12 IS NULL;
2326:

Line 2341: l_rec_avc_eei_info pay_element_type_extra_info%ROWTYPE;

2337:
2338: l_proc_name VARCHAR2(80)
2339: := g_proc_name || 'get_avc_pen_balance_details';
2340: l_proc_step PLS_INTEGER;
2341: l_rec_avc_eei_info pay_element_type_extra_info%ROWTYPE;
2342: l_ele_classification pay_element_classifications.classification_name%TYPE;
2343: l_element_type_id NUMBER;
2344: l_scheme_prefix pay_element_type_extra_info.eei_information18%TYPE;
2345: l_balance_name pay_balance_types.balance_name%TYPE;

Line 2344: l_scheme_prefix pay_element_type_extra_info.eei_information18%TYPE;

2340: l_proc_step PLS_INTEGER;
2341: l_rec_avc_eei_info pay_element_type_extra_info%ROWTYPE;
2342: l_ele_classification pay_element_classifications.classification_name%TYPE;
2343: l_element_type_id NUMBER;
2344: l_scheme_prefix pay_element_type_extra_info.eei_information18%TYPE;
2345: l_balance_name pay_balance_types.balance_name%TYPE;
2346: l_balance_type_id NUMBER;
2347: l_defined_bal_id NUMBER;
2348: -- For 115.29

Line 2524: l_scheme_prefix pay_element_type_extra_info.eei_information18%TYPE;

2520: i NUMBER;
2521: l_error_code NUMBER;
2522: l_error_message VARCHAR2(2400);
2523: l_year VARCHAR2(10);
2524: l_scheme_prefix pay_element_type_extra_info.eei_information18%TYPE;
2525: l_tab_avc_pen_bal_dtls t_ele_bal_dtls;
2526: l_psi_pens_category pqp_configuration_values.pcv_information1%TYPE;
2527: l_template_pens_category pay_element_type_extra_info.eei_information4%TYPE;
2528: l_rec_pen_bal_dtls r_pen_bal_dtls;

Line 2527: l_template_pens_category pay_element_type_extra_info.eei_information4%TYPE;

2523: l_year VARCHAR2(10);
2524: l_scheme_prefix pay_element_type_extra_info.eei_information18%TYPE;
2525: l_tab_avc_pen_bal_dtls t_ele_bal_dtls;
2526: l_psi_pens_category pqp_configuration_values.pcv_information1%TYPE;
2527: l_template_pens_category pay_element_type_extra_info.eei_information4%TYPE;
2528: l_rec_pen_bal_dtls r_pen_bal_dtls;
2529: l_rec_eeit_info pay_element_type_extra_info%ROWTYPE;
2530: l_element_name pay_element_types_f.element_name%TYPE;
2531: --

Line 2529: l_rec_eeit_info pay_element_type_extra_info%ROWTYPE;

2525: l_tab_avc_pen_bal_dtls t_ele_bal_dtls;
2526: l_psi_pens_category pqp_configuration_values.pcv_information1%TYPE;
2527: l_template_pens_category pay_element_type_extra_info.eei_information4%TYPE;
2528: l_rec_pen_bal_dtls r_pen_bal_dtls;
2529: l_rec_eeit_info pay_element_type_extra_info%ROWTYPE;
2530: l_element_name pay_element_types_f.element_name%TYPE;
2531: --
2532: BEGIN
2533: --