APPS.PQP_GB_SCOTLAND_LGPS_PENSIONPY dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 380: FROM pay_element_type_extra_info pet

376: -- 7369484 Start Changes made in cursor to fetch both rate types
377: CURSOR c2_PQP_UK_RATE_TYPE(n_element_type_id NUMBER)
378: IS
379: SELECT pet.EEI_INFORMATION1
380: FROM pay_element_type_extra_info pet
381: WHERE pet.element_type_id = n_element_type_id
382: AND pet.INFORMATION_TYPE = 'PQP_UK_RATE_TYPE'
383: AND pet.EEI_INFORMATION1 IN ('PQP_LGPS_PENSION_PAY','PQP_LGPS_SCOTLAND_PENSION_PAY');
384: -- 7369484 End

Line 388: FROM pay_element_type_extra_info pet

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

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

640: End if;
641: End loop;
642: --6666135 End
643:
644: --To Check the values PQP_UK_RATE_TYPE, PQP_LGPS_PENSION_PAY, INPUT_VALUE AND PAY VALUE in pay_element_type_extra_info
645: OPEN c2_PQP_UK_RATE_TYPE(c1_all_element_data.element_type_id);
646: FETCH c2_PQP_UK_RATE_TYPE INTO c2_PQP_UK_RATE_TYPE_data;
647: IF c2_PQP_UK_RATE_TYPE%NOTFOUND
648: THEN