eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_PRORATION_WRAPPER dependencies on FF_FORMULAS_F

Line 34: FROM ff_formulas_f

30: AND name = LTRIM(RTRIM(p_input_value_name));
31:
32: CURSOR c_formula_id(p_formula_name IN VARCHAR2) IS
33: SELECT formula_id
34: FROM ff_formulas_f
35: WHERE formula_name = UPPER(p_formula_name);
36:
37: CURSOR c_element_extra_info_cnt(p_ele_id IN NUMBER) IS
38: SELECT COUNT(*) count

Line 59: FROM ff_formulas_f ff

55: WHERE UPPER(event_group_name) = UPPER(p_pg_name);
56:
57: CURSOR c_formula_text(p_formula_name IN VARCHAR) IS
58: SELECT formula_text
59: FROM ff_formulas_f ff
60: WHERE ff.formula_name = p_formula_name
61: AND ff.legislation_code = 'GB'
62: AND ff.business_group_id IS NULL;
63:

Line 67: FROM ff_formulas_f ff

63:
64: CURSOR c_fast_formula_id(p_formula_name IN VARCHAR,
65: p_business_group_id IN NUMBER) IS
66: SELECT formula_id
67: FROM ff_formulas_f ff
68: WHERE RTRIM(LTRIM(UPPER(ff.formula_name)))
69: = RTRIM(LTRIM(UPPER(p_formula_name)))
70: AND ff.legislation_code IS NULL
71: AND ff.business_group_id = p_business_group_id;

Line 638: FROM ff_formulas_f

634: l_count := 0;
635:
636: SELECT COUNT(*)
637: INTO l_count
638: FROM ff_formulas_f
639: WHERE formula_name = UPPER(l_modified_base_formula || '_sal_ff');
640:
641: IF (l_count = 0) THEN
642: hr_utility.trace('If condition ... count = 0');

Line 651: -- FROM ff_formulas_f ff

647: WHERE formula_type_name = 'Oracle Payroll';
648:
649: -- SELECT formula_text
650: -- INTO l_formula_text
651: -- FROM ff_formulas_f ff
652: -- WHERE ff.formula_name = 'UK_PRORATION_SAL_MANAGEMENT'
653: -- AND ff.legislation_code = 'GB'
654: -- AND ff.business_group_id IS NULL;
655:

Line 670: INSERT INTO ff_formulas_f

666: 'UK_PRORATION_SAL_MANAGEMENT',
667: l_formula_name);
668: l_description := 'Formula for Salary Management';
669:
670: INSERT INTO ff_formulas_f
671: (formula_id ,
672: effective_start_date ,
673: effective_end_date ,
674: business_group_id ,

Line 703: -- FROM ff_formulas_f ff

699: SYSDATE ); -- creation_date
700:
701: -- SELECT formula_id
702: -- INTO l_formula_id
703: -- FROM ff_formulas_f ff
704: -- WHERE ff.formula_name = l_formula_name
705: -- AND ff.legislation_code IS NULL
706: -- AND ff.business_group_id = l_business_group_id;
707:

Line 753: FROM ff_formulas_f

749: l_count := 0;
750:
751: SELECT COUNT(*)
752: INTO l_count
753: FROM ff_formulas_f
754: WHERE formula_name = UPPER(l_modified_base_formula || '_sal_ff1');
755:
756: IF (l_count = 0) THEN
757: hr_utility.trace('If condition ... count = 0');

Line 766: -- FROM ff_formulas_f ff

762: WHERE formula_type_name = 'Oracle Payroll';
763:
764: -- SELECT formula_text
765: -- INTO l_formula_text
766: -- FROM ff_formulas_f ff
767: -- WHERE ff.formula_name = 'UK_PRORATION_ALLOWANCE'
768: -- AND ff.legislation_code = 'GB'
769: -- AND ff.business_group_id IS NULL;
770:

Line 786: INSERT INTO ff_formulas_f

782: 'UK_PRORATION_ALLOWANCE',
783: l_formula_name);
784: l_description := 'Formula for Salary Management';
785:
786: INSERT INTO ff_formulas_f
787: (formula_id ,
788: effective_start_date ,
789: effective_end_date ,
790: business_group_id ,

Line 819: -- FROM ff_formulas_f ff

815: SYSDATE ); -- creation_date
816:
817: -- SELECT formula_id
818: -- INTO l_formula_id
819: -- FROM ff_formulas_f ff
820: -- WHERE ff.formula_name = l_formula_name
821: -- AND ff.legislation_code IS NULL
822: -- AND ff.business_group_id = l_business_group_id;
823:

Line 1095: FROM ff_formulas_f

1091: l_count := 0;
1092:
1093: SELECT COUNT(*)
1094: INTO l_count
1095: FROM ff_formulas_f
1096: WHERE formula_name = UPPER(l_modified_base_formula || '_grade_ff');
1097:
1098: IF (l_count = 0) THEN
1099: hr_utility.trace('If condition ...creating formula');

Line 1107: -- FROM ff_formulas_f ff

1103: WHERE formula_type_name = 'Oracle Payroll';
1104:
1105: -- SELECT formula_text
1106: -- INTO l_formula_text
1107: -- FROM ff_formulas_f ff
1108: -- WHERE ff.formula_name = 'UK_PRORATION_GRADE_RATE'
1109: -- AND ff.legislation_code = 'GB'
1110: -- AND ff.business_group_id IS NULL;
1111:

Line 1126: INSERT INTO ff_formulas_f

1122:
1123: l_formula_text := REPLACE(l_formula_text, 'UK Grade Rate',
1124: l_modified_base_ele || ' grade ele' );
1125:
1126: INSERT INTO ff_formulas_f
1127: (formula_id ,
1128: effective_start_date ,
1129: effective_end_date ,
1130: business_group_id ,

Line 1159: -- FROM ff_formulas_f ff

1155: SYSDATE ); -- creation_date
1156:
1157: -- SELECT formula_id
1158: -- INTO l_formula_id
1159: -- FROM ff_formulas_f ff
1160: -- WHERE ff.formula_name = l_formula_name
1161: -- AND ff.legislation_code IS NULL
1162: -- AND ff.business_group_id = l_business_group_id;
1163:

Line 1474: FROM ff_formulas_f

1470: l_count := 0;
1471:
1472: SELECT COUNT(*)
1473: INTO l_count
1474: FROM ff_formulas_f
1475: WHERE formula_name = UPPER(l_modified_base_ele || '_payscale_ff');
1476:
1477: IF (l_count = 0) THEN
1478: SELECT formula_type_id

Line 1485: -- FROM ff_formulas_f ff

1481: WHERE formula_type_name = 'Oracle Payroll';
1482:
1483: -- SELECT formula_text
1484: -- INTO l_formula_text
1485: -- FROM ff_formulas_f ff
1486: -- WHERE ff.formula_name = 'UK_PRORATION_SPINAL_POINT'
1487: -- AND ff.legislation_code = 'GB'
1488: -- AND ff.business_group_id IS NULL;
1489:

Line 1504: INSERT INTO ff_formulas_f

1500:
1501: l_formula_text := REPLACE(l_formula_text, 'UK Spinal Point',
1502: l_modified_base_ele || ' payscale ele');
1503:
1504: INSERT INTO ff_formulas_f
1505: ( formula_id ,
1506: effective_start_date ,
1507: effective_end_date ,
1508: business_group_id ,

Line 1537: -- FROM ff_formulas_f ff

1533: SYSDATE ); -- creation_date
1534:
1535: -- SELECT formula_id
1536: -- INTO l_formula_id
1537: -- FROM ff_formulas_f ff
1538: -- WHERE ff.formula_name = l_formula_name
1539: -- AND ff.legislation_code IS NULL
1540: -- AND ff.business_group_id = l_business_group_id;
1541:

Line 2245: FROM ff_formulas_f

2241: SUBSTR(UPPER(REPLACE(p_ele_name_fr, ' ', '_') || '_FF'), 1, 80);
2242:
2243: SELECT COUNT(*)
2244: INTO l_count
2245: FROM ff_formulas_f
2246: WHERE formula_name = l_new_formula_name ;
2247:
2248: IF (l_count = 0) THEN
2249:

Line 2257: -- FROM ff_formulas_f ff

2253: WHERE formula_type_name = 'Oracle Payroll';
2254:
2255: -- SELECT formula_text
2256: -- INTO l_formula_text
2257: -- FROM ff_formulas_f ff
2258: -- WHERE ff.formula_name = l_formula_name
2259: -- AND ff.legislation_code = 'GB'
2260: -- AND ff.business_group_id IS NULL;
2261:

Line 2311: INSERT INTO ff_formulas_f

2307: END LOOP;
2308:
2309: l_description := 'Formula created for ' || p_ele_name_fr;
2310:
2311: INSERT INTO ff_formulas_f
2312: (formula_id ,
2313: effective_start_date ,
2314: effective_end_date ,
2315: business_group_id ,

Line 2345: -- FROM ff_formulas_f ff

2341: SYSDATE ); -- creation_date
2342:
2343: -- SELECT formula_id
2344: -- INTO l_formula_id
2345: -- FROM ff_formulas_f ff
2346: -- WHERE ff.formula_name = l_new_formula_name
2347: -- AND ff.legislation_code IS NULL
2348: -- AND ff.business_group_id = l_business_group_id;
2349: FOR cffi IN c_fast_formula_id(l_new_formula_name,