APPS.PQP_GB_LGPS_PENSIONPAY dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 377: FROM pay_element_type_extra_info pet

373: -- --7369484 Begin Cursor including Scottish LGPS Rate Type
374: CURSOR c2_PQP_UK_RATE_TYPE(n_element_type_id NUMBER)
375: IS
376: SELECT pet.EEI_INFORMATION1
377: FROM pay_element_type_extra_info pet
378: WHERE pet.element_type_id = n_element_type_id
379: AND pet.INFORMATION_TYPE = 'PQP_UK_RATE_TYPE'
380: -- AND pet.EEI_INFORMATION1 = 'PQP_LGPS_PENSION_PAY';
381: AND pet.EEI_INFORMATION1 in ('PQP_LGPS_SCOTLAND_PENSION_PAY','PQP_LGPS_PENSION_PAY');

Line 387: FROM pay_element_type_extra_info pet

383:
384: CURSOR c3_pqp_lgps_pension_pay(n_element_type_id NUMBER)
385: IS
386: SELECT 1
387: FROM pay_element_type_extra_info pet
388: WHERE pet.element_type_id = n_element_type_id
389: AND pet.INFORMATION_TYPE = 'PQP_UK_ELEMENT_ATTRIBUTION';
390:
391:

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

634: End if;
635: End loop;
636: --6666135 End
637:
638: --To Check the values PQP_UK_RATE_TYPE, PQP_LGPS_PENSION_PAY, INPUT_VALUE AND PAY VALUE in pay_element_type_extra_info
639: OPEN c2_PQP_UK_RATE_TYPE(c1_all_element_data.element_type_id);
640: FETCH c2_PQP_UK_RATE_TYPE INTO c2_PQP_UK_RATE_TYPE_data;
641: IF c2_PQP_UK_RATE_TYPE%NOTFOUND
642: THEN