APPS.PQP_GB_OSP_TEMPLATE dependencies on PQP_CONFIGURATION_TYPES

Line 543: INSERT INTO PQP_CONFIGURATION_TYPES

539: where module_name = 'Absence Schemes'
540: and legislation_code = 'GB' ;
541:
542:
543: INSERT INTO PQP_CONFIGURATION_TYPES
544: ( CONFIGURATION_TYPE -- 'PQP_GB_OSP_OMP_CONFIG'
545: ,MODULE_ID -- l_module_id -- sequence of above row
546: ,ACTIVE_INACTIVE_FLAG -- 'Y'
547: ,DESCRIPTION -- 'OSP/OMP Absence Schemes Configuration'

Line 584: ( SELECT 1 FROM pqp_configuration_types

580: ,hr_api.g_sot
581: ,NULL
582: FROM DUAL
583: WHERE NOT EXISTS
584: ( SELECT 1 FROM pqp_configuration_types
585: WHERE configuration_type = 'PQP_GB_OSP_OMP_CONFIG'
586: AND module_id = l_module_id
587: AND legislation_code = 'GB'
588: ) ;

Line 3169: -- ,pqp_configuration_types table.

3165: ) ;
3166:
3167: -- Elements Links are created Here
3168: -- creates values in pqp_configuration_modules
3169: -- ,pqp_configuration_types table.
3170: -- once the lct, ldt are finalized to ship these values this code
3171: -- will be replaced by a proper ldt.
3172:
3173: create_config_data ;