APPS.PQP_GB_AD_EE dependencies on PQP_CONFIGURATION_VALUES

Line 957: FROM pqp_configuration_values

953: --Cursor to fetch Nuvos and Partnership elements
954: Cursor csr_get_nuv_part_elements(c_business_group_id number)
955: IS
956: SELECT pcv_information1 --element_type_id
957: FROM pqp_configuration_values
958: WHERE pcv_information_category = 'PQP_GB_PENSERV_SCHEME_MAP_INFO'
959: AND business_group_id =c_business_group_id
960: AND pcv_information2 in ('NUVOS','PARTNER');
961: --

Line 969: FROM pqp_configuration_values

965: IS
966: SELECT pcv_information1, --penserver_eligibility_context
967: pcv_information2, --mapped_segment
968: pcv_information3 --mapped_dff_segment
969: FROM pqp_configuration_values
970: WHERE pcv_information_category='PQP_GB_PENSERVER_ELIGBLTY_CONF'
971: AND business_group_id = c_business_group_id;
972: --
973: --Cursor to fetch Employment categories mapped to Casual for penserver

Line 977: FROM pqp_configuration_values

973: --Cursor to fetch Employment categories mapped to Casual for penserver
974: Cursor csr_get_casual_emp_cate(c_business_group_id number)
975: IS
976: SELECT pcv_information1 --mapped_casual_emp_categories
977: FROM pqp_configuration_values
978: WHERE pcv_information_category='PQP_GB_PENSERVER_EMPLYMT_TYPE'
979: AND business_group_id = c_business_group_id
980: AND pcv_information2 = 'CASUAL';
981: --

Line 986: FROM pqp_configuration_values

982: --Cursor to fetch Employment categories mapped to Fixed and Regular for penserver
983: Cursor csr_get_non_casual_emp_cate(c_business_group_id number)
984: IS
985: SELECT pcv_information1 --mapped_non_casual_emp_cate
986: FROM pqp_configuration_values
987: WHERE pcv_information_category='PQP_GB_PENSERVER_EMPLYMT_TYPE'
988: AND business_group_id = c_business_group_id
989: AND pcv_information2 in ('FIXED','REGULAR');
990: --