APPS.PQP_GB_UNPAID_TEMPLATE dependencies on STANDARD

Line 2061: -- benefit standard rates

2057: AND business_group_id = p_business_group_id
2058: AND template_type = 'U';
2059:
2060: -- Cursor to check whether elements are attached to
2061: -- benefit standard rates
2062:
2063: CURSOR csr_chk_ele_in_ben (c_element_type_id number)
2064: IS
2065: SELECT 'X'

Line 2174: -- standard rate formula before deleting them

2170: FETCH csr_get_ele_type_id INTO l_element_type_id;
2171: EXIT WHEN csr_get_ele_type_id%NOTFOUND;
2172:
2173: -- Check whether elements are attached to benefits
2174: -- standard rate formula before deleting them
2175:
2176: l_proc_step := 25;
2177: IF g_debug THEN
2178: debug(l_proc_name, l_proc_step);

Line 2190: hr_utility.set_message_token('TYPE','Standard Rates, Table: BEN_ACTY_BASE_RT_F');

2186:
2187: -- Raise Error
2188: Close csr_chk_ele_in_ben;
2189: hr_utility.set_message (800,'PER_74880_CHILD_RECORD');
2190: hr_utility.set_message_token('TYPE','Standard Rates, Table: BEN_ACTY_BASE_RT_F');
2191: hr_utility.raise_error;
2192:
2193: END IF; -- End if of element in ben check ...
2194: CLOSE csr_chk_ele_in_ben;