APPS.PQP_GB_SCOTLAND_LGPS_PENSIONPY dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 366: FROM pay_element_type_extra_info pet

362: -- 7369484 Start Changes made in cursor to fetch both rate types
363: CURSOR c2_PQP_UK_RATE_TYPE(n_element_type_id NUMBER)
364: IS
365: SELECT pet.EEI_INFORMATION1
366: FROM pay_element_type_extra_info pet
367: WHERE pet.element_type_id = n_element_type_id
368: AND pet.INFORMATION_TYPE = 'PQP_UK_RATE_TYPE'
369: AND pet.EEI_INFORMATION1 IN ('PQP_LGPS_PENSION_PAY','PQP_LGPS_SCOTLAND_PENSION_PAY');
370: -- 7369484 End

Line 374: FROM pay_element_type_extra_info pet

370: -- 7369484 End
371: CURSOR c3_pqp_lgps_pension_pay(n_element_type_id NUMBER)
372: IS
373: SELECT 1
374: FROM pay_element_type_extra_info pet
375: WHERE pet.element_type_id = n_element_type_id
376: AND pet.INFORMATION_TYPE = 'PQP_UK_ELEMENT_ATTRIBUTION';
377:
378:

Line 630: --To Check the values PQP_UK_RATE_TYPE, PQP_LGPS_PENSION_PAY, INPUT_VALUE AND PAY VALUE in pay_element_type_extra_info

626: End if;
627: End loop;
628: --6666135 End
629:
630: --To Check the values PQP_UK_RATE_TYPE, PQP_LGPS_PENSION_PAY, INPUT_VALUE AND PAY VALUE in pay_element_type_extra_info
631: OPEN c2_PQP_UK_RATE_TYPE(c1_all_element_data.element_type_id);
632: FETCH c2_PQP_UK_RATE_TYPE INTO c2_PQP_UK_RATE_TYPE_data;
633: IF c2_PQP_UK_RATE_TYPE%NOTFOUND
634: THEN