APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 564: ,p_rec_eeit_info OUT NOCOPY pay_element_type_extra_info%ROWTYPE

560: -- ----------------------------------------------------------------------------
561: PROCEDURE get_eeit_info(
562: p_element_type_id IN NUMBER
563: ,p_information_type IN VARCHAR2
564: ,p_rec_eeit_info OUT NOCOPY pay_element_type_extra_info%ROWTYPE
565: )
566: IS
567: --
568: -- Cursor to get eei information

Line 572: FROM pay_element_type_extra_info

568: -- Cursor to get eei information
569: CURSOR csr_get_eei_info
570: IS
571: SELECT *
572: FROM pay_element_type_extra_info
573: WHERE element_type_id = p_element_type_id
574: AND information_type = p_information_type;
575:
576: l_proc_name VARCHAR2(80) := g_proc_name || 'get_eeit_info';

Line 578: l_rec_eeit_info pay_element_type_extra_info%ROWTYPE;

574: AND information_type = p_information_type;
575:
576: l_proc_name VARCHAR2(80) := g_proc_name || 'get_eeit_info';
577: l_proc_step PLS_INTEGER;
578: l_rec_eeit_info pay_element_type_extra_info%ROWTYPE;
579: --
580: BEGIN
581: --
582: IF g_debug

Line 2478: FROM pay_element_type_extra_info

2474: -- Cursor to fetch eei information
2475: CURSOR csr_get_avc_eei_info
2476: IS
2477: SELECT *
2478: FROM pay_element_type_extra_info
2479: WHERE information_type = p_information_type
2480: AND eei_information16 = p_associated_ocp_ele_id
2481: AND eei_information12 IS NULL;
2482:

Line 2497: l_rec_avc_eei_info pay_element_type_extra_info%ROWTYPE;

2493:
2494: l_proc_name VARCHAR2(80)
2495: := g_proc_name || 'get_avc_pen_balance_details';
2496: l_proc_step PLS_INTEGER;
2497: l_rec_avc_eei_info pay_element_type_extra_info%ROWTYPE;
2498: l_ele_classification pay_element_classifications.classification_name%TYPE;
2499: l_element_type_id NUMBER;
2500: l_scheme_prefix pay_element_type_extra_info.eei_information18%TYPE;
2501: l_balance_name pay_balance_types.balance_name%TYPE;

Line 2500: l_scheme_prefix pay_element_type_extra_info.eei_information18%TYPE;

2496: l_proc_step PLS_INTEGER;
2497: l_rec_avc_eei_info pay_element_type_extra_info%ROWTYPE;
2498: l_ele_classification pay_element_classifications.classification_name%TYPE;
2499: l_element_type_id NUMBER;
2500: l_scheme_prefix pay_element_type_extra_info.eei_information18%TYPE;
2501: l_balance_name pay_balance_types.balance_name%TYPE;
2502: l_balance_type_id NUMBER;
2503: l_defined_bal_id NUMBER;
2504: -- For 115.29

Line 2680: l_scheme_prefix pay_element_type_extra_info.eei_information18%TYPE;

2676: i NUMBER;
2677: l_error_code NUMBER;
2678: l_error_message VARCHAR2(2400);
2679: l_year VARCHAR2(10);
2680: l_scheme_prefix pay_element_type_extra_info.eei_information18%TYPE;
2681: l_tab_avc_pen_bal_dtls t_ele_bal_dtls;
2682: l_psi_pens_category pqp_configuration_values.pcv_information1%TYPE;
2683: l_template_pens_category pay_element_type_extra_info.eei_information4%TYPE;
2684: l_rec_pen_bal_dtls r_pen_bal_dtls;

Line 2683: l_template_pens_category pay_element_type_extra_info.eei_information4%TYPE;

2679: l_year VARCHAR2(10);
2680: l_scheme_prefix pay_element_type_extra_info.eei_information18%TYPE;
2681: l_tab_avc_pen_bal_dtls t_ele_bal_dtls;
2682: l_psi_pens_category pqp_configuration_values.pcv_information1%TYPE;
2683: l_template_pens_category pay_element_type_extra_info.eei_information4%TYPE;
2684: l_rec_pen_bal_dtls r_pen_bal_dtls;
2685: l_rec_eeit_info pay_element_type_extra_info%ROWTYPE;
2686: l_element_name pay_element_types_f.element_name%TYPE;
2687: --

Line 2685: l_rec_eeit_info pay_element_type_extra_info%ROWTYPE;

2681: l_tab_avc_pen_bal_dtls t_ele_bal_dtls;
2682: l_psi_pens_category pqp_configuration_values.pcv_information1%TYPE;
2683: l_template_pens_category pay_element_type_extra_info.eei_information4%TYPE;
2684: l_rec_pen_bal_dtls r_pen_bal_dtls;
2685: l_rec_eeit_info pay_element_type_extra_info%ROWTYPE;
2686: l_element_name pay_element_types_f.element_name%TYPE;
2687: --
2688: BEGIN
2689: --