APPS.PQP_PRORATION_WRAPPER dependencies on PAY_ELEMENT_TYPES_F

Line 22: FROM pay_element_types_f

18: AND UPPER(classification_name) = UPPER(p_primary_class);
19:
20: CURSOR c_element_id(p_ele_name IN VARCHAR2) IS
21: SELECT element_type_id
22: FROM pay_element_types_f
23: WHERE UPPER(element_name) = UPPER(LTRIM(RTRIM(p_ele_name)));
24:
25: CURSOR c_input_value(p_element_type_id IN NUMBER ,
26: p_input_value_name IN VARCHAR2 ) IS

Line 511: FROM pay_element_types_f

507: l_count := 0;
508:
509: SELECT COUNT(*)
510: INTO l_count
511: FROM pay_element_types_f
512: WHERE UPPER(element_name) =
513: UPPER(l_modified_base_ele || ' sal ele');
514:
515: IF (l_count = 0) THEN

Line 575: FROM pay_element_types_f

571: l_count := 0;
572:
573: SELECT COUNT(*)
574: INTO l_count
575: FROM pay_element_types_f
576: WHERE UPPER(element_name) =
577: UPPER(l_modified_base_ele || ' sal ele1');
578:
579: IF (l_count = 0) THEN

Line 984: FROM pay_element_types_f

980: l_count := 0;
981:
982: SELECT COUNT(*)
983: INTO l_count
984: FROM pay_element_types_f
985: WHERE UPPER(element_name) = UPPER(l_modified_base_ele || ' grade ele');
986:
987: IF (l_count = 0) THEN
988: hr_utility.trace('If condition ... creating elements');

Line 1354: FROM pay_element_types_f

1350: l_count := 0;
1351:
1352: SELECT COUNT(*)
1353: INTO l_count
1354: FROM pay_element_types_f
1355: WHERE UPPER(element_name) =
1356: UPPER(l_modified_base_ele || ' payscale ele');
1357: hr_utility.trace('The count is ' || TO_CHAR(l_count));
1358:

Line 1969: FROM pay_element_types_f

1965: l_business_group_name := p_business_group;
1966:
1967: SELECT COUNT(*)
1968: INTO l_count
1969: FROM pay_element_types_f
1970: WHERE UPPER(element_name) = UPPER(LTRIM(RTRIM(p_ele_name)));
1971:
1972: hr_utility.trace('The count is ' || TO_CHAR(l_count) );
1973:

Line 2363: -- FROM pay_element_types_f

2359: argument2 => l_new_formula_name );
2360:
2361: -- SELECT element_type_id
2362: -- INTO l_ele_id
2363: -- FROM pay_element_types_f
2364: -- WHERE UPPER(element_name) = UPPER(LTRIM(RTRIM(p_ele_name_fr)));
2365:
2366: FOR ceti IN c_element_id(p_ele_name_fr)
2367: LOOP