DBA Data[Home] [Help]

APPS.PQP_FEDHR_USPAY_INT_UTILS dependencies on GHR_GENERAL

Line 68: SELECT ghr_general.return_NUMBER(pcv.pcv_information2) element_type_id,

64:
65: CURSOR chk_pqp_config_tab(p_business_group_id
66: per_business_groups.business_group_id%TYPE,
67: p_pay_basis VARCHAR2) IS
68: SELECT ghr_general.return_NUMBER(pcv.pcv_information2) element_type_id,
69: pcv.pcv_information1 element_old_name,
70: NVL(pcv.pcv_information3,'NULL') pay_basis
71: FROM pqp_configuration_values pcv
72: WHERE pcv.pcv_information_category = 'PQP_FEDHR_ELEMENT'

Line 690: SELECT ghr_general.return_NUMBER(pcv.pcv_information2) element_type_id,

686: AND p_effective_date BETWEEN ele.effective_start_date
687: AND ele.effective_end_date;
688:
689: CURSOR chk_pqp_config_tab(p_business_group_id per_business_groups.business_group_id%TYPE) IS
690: SELECT ghr_general.return_NUMBER(pcv.pcv_information2) element_type_id,
691: pcv.pcv_information1 element_old_name,
692: NVL(pcv.pcv_information3,'NULL') pay_basis
693: FROM pqp_configuration_values pcv
694: WHERE pcv.pcv_information_category = 'PQP_FEDHR_ELEMENT'

Line 696: AND ghr_general.return_number(pcv.pcv_information2) = l_element_type_id

692: NVL(pcv.pcv_information3,'NULL') pay_basis
693: FROM pqp_configuration_values pcv
694: WHERE pcv.pcv_information_category = 'PQP_FEDHR_ELEMENT'
695: AND pcv.business_group_id = p_business_group_id
696: AND ghr_general.return_number(pcv.pcv_information2) = l_element_type_id
697: ORDER BY pcv.pcv_information1;
698:
699: /****
700: CURSOR element_type_cursor(p_element_type_id