APPS.PQP_GB_LGPS_PENSIONPAY dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 364: FROM pay_element_type_extra_info pet

360: -- --7369484 Begin Cursor including Scottish LGPS Rate Type
361: CURSOR c2_PQP_UK_RATE_TYPE(n_element_type_id NUMBER)
362: IS
363: SELECT pet.EEI_INFORMATION1
364: FROM pay_element_type_extra_info pet
365: WHERE pet.element_type_id = n_element_type_id
366: AND pet.INFORMATION_TYPE = 'PQP_UK_RATE_TYPE'
367: -- AND pet.EEI_INFORMATION1 = 'PQP_LGPS_PENSION_PAY';
368: AND pet.EEI_INFORMATION1 in ('PQP_LGPS_SCOTLAND_PENSION_PAY','PQP_LGPS_PENSION_PAY');

Line 374: FROM pay_element_type_extra_info pet

370:
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 625: --To Check the values PQP_UK_RATE_TYPE, PQP_LGPS_PENSION_PAY, INPUT_VALUE AND PAY VALUE in pay_element_type_extra_info

621: End if;
622: End loop;
623: --6666135 End
624:
625: --To Check the values PQP_UK_RATE_TYPE, PQP_LGPS_PENSION_PAY, INPUT_VALUE AND PAY VALUE in pay_element_type_extra_info
626: OPEN c2_PQP_UK_RATE_TYPE(c1_all_element_data.element_type_id);
627: FETCH c2_PQP_UK_RATE_TYPE INTO c2_PQP_UK_RATE_TYPE_data;
628: IF c2_PQP_UK_RATE_TYPE%NOTFOUND
629: THEN