APPS.PQP_FEDHR_USPAY_INT_UTILS dependencies on PER_BUSINESS_GROUPS

Line 66: per_business_groups.business_group_id%TYPE,

62: p_pay_basis IN VARCHAR2
63: ) RETURN VARCHAR2 IS
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

Line 81: per_business_groups.business_group_id%TYPE,

77:
78: CURSOR element_type_cursor(p_element_type_id
79: pay_element_types_f.element_type_id%TYPE,
80: p_business_group_id
81: per_business_groups.business_group_id%TYPE,
82: p_effective_date DATE) IS
83: SELECT pet.element_name element_new_name
84: FROM pay_element_types_f pet
85: WHERE pet.business_group_id = p_business_group_id

Line 264: per_business_groups.business_group_id%TYPE,

260: p_effective_date IN DATE
261: ) RETURN VARCHAR2 IS
262:
263: CURSOR chk_per_pay_bases(p_business_group_id
264: per_business_groups.business_group_id%TYPE,
265: p_salary_basis VARCHAR2,
266: p_effective_date DATE) IS
267: SELECT element_name
268: FROM per_pay_bases ppb,

Line 344: per_business_groups.business_group_id%TYPE,

340: p_business_group_id IN NUMBER ,
341: p_effective_date IN DATE
342: ) RETURN VARCHAR2 IS
343: CURSOR chk_per_pay_bases(p_business_group_id
344: per_business_groups.business_group_id%TYPE,
345: p_salary_basis_id NUMBER,
346: p_effective_date DATE) IS
347: SELECT element_name
348: FROM per_pay_bases ppb,

Line 364: per_business_groups.business_group_id%TYPE,

360: pet.effective_end_date;
361:
362: CURSOR get_sal_basis_id(p_assignment_id NUMBER ,
363: p_business_group_id
364: per_business_groups.business_group_id%TYPE,
365: p_effective_date DATE) IS
366: SELECT pay_basis_id
367: FROM per_all_assignments_f
368: WHERE assignment_id = p_assignment_id

Line 689: CURSOR chk_pqp_config_tab(p_business_group_id per_business_groups.business_group_id%TYPE) IS

685: AND business_group_id = p_business_group_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

Line 703: per_business_groups.business_group_id%TYPE,

699: /****
700: CURSOR element_type_cursor(p_element_type_id
701: pay_element_types_f.element_type_id%TYPE,
702: p_business_group_id
703: per_business_groups.business_group_id%TYPE,
704: p_effective_date DATE) IS
705: SELECT pet.element_name element_new_name
706: FROM pay_element_types_f pet
707: WHERE pet.business_group_id = p_business_group_id