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 PAY_EVENT_GROUPS

Line 54: FROM pay_event_groups

50: AND eei_information_category = 'PQP_UK_ELEMENT_ATTRIBUTION';
51:
52: CURSOR c_event_group_id(p_pg_name IN VARCHAR) IS
53: SELECT event_group_id
54: FROM pay_event_groups
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

Line 401: -- PAY_EVENT_GROUPS_API.CREATE_EVENT_GROUP

397:
398: -- a) Step a
399:
400: -- PAY_DATETRACKED_EVENTS_API. CREATE_DATETRACKED_EVENT
401: -- PAY_EVENT_GROUPS_API.CREATE_EVENT_GROUP
402:
403: l_count := 0;
404:
405: SELECT COUNT(*)

Line 407: FROM pay_event_groups

403: l_count := 0;
404:
405: SELECT COUNT(*)
406: INTO l_count
407: FROM pay_event_groups
408: WHERE event_group_name = UPPER(l_modified_base_pg || ' sal pg');
409:
410: hr_utility.trace('The count 15 is ' || TO_CHAR(l_count));
411:

Line 415: pay_event_groups_api.create_event_group

411:
412: IF (l_count = 0) THEN
413: hr_utility.trace('If condition ... Creating Even Group');
414:
415: pay_event_groups_api.create_event_group
416: (
417: p_effective_date => TO_DATE(l_date,'dd/mm/yyyy')
418: ,p_event_group_name => UPPER(l_modified_base_pg || ' sal pg')
419: ,p_event_group_type => 'P'

Line 432: -- FROM pay_event_groups

428: l_event_group_id := NULL;
429:
430: -- SELECT event_group_id
431: -- INTO l_event_group_id
432: -- FROM pay_event_groups
433: -- WHERE event_group_name = UPPER(l_modified_base_pg || ' sal pg');
434:
435: FOR cegi IN c_event_group_id(l_modified_base_pg || ' sal pg')
436: LOOP

Line 876: -- PAY_EVENT_GROUPS_API.CREATE_EVENT_GROUP

872:
873: -- a) Step a
874:
875: -- PAY_DATETRACKED_EVENTS_API. CREATE_DATETRACKED_EVENT
876: -- PAY_EVENT_GROUPS_API.CREATE_EVENT_GROUP
877:
878: l_count := 0;
879:
880: SELECT COUNT(*)

Line 882: FROM pay_event_groups

878: l_count := 0;
879:
880: SELECT COUNT(*)
881: INTO l_count
882: FROM pay_event_groups
883: WHERE event_group_name = UPPER(l_modified_base_pg || ' GRADE pg');
884:
885: IF (l_count = 0 ) THEN
886: hr_utility.trace('If condition ... creating event group');

Line 887: pay_event_groups_api.create_event_group

883: WHERE event_group_name = UPPER(l_modified_base_pg || ' GRADE pg');
884:
885: IF (l_count = 0 ) THEN
886: hr_utility.trace('If condition ... creating event group');
887: pay_event_groups_api.create_event_group
888: (
889: p_effective_date => TO_DATE(l_date,'dd/mm/yyyy')
890: ,p_event_group_name => UPPER(l_modified_base_pg || ' grade pg')
891: ,p_event_group_type => 'P'

Line 904: -- FROM pay_event_groups

900: l_event_group_id := NULL;
901:
902: -- SELECT event_group_id
903: -- INTO l_event_group_id
904: -- FROM pay_event_groups
905: -- WHERE event_group_name = UPPER(l_modified_base_pg || ' GRADE pg');
906: FOR cegi1 IN c_event_group_id(l_modified_base_pg || ' GRADE pg')
907: LOOP
908: l_event_group_id := cegi1.event_group_id;

Line 1215: -- PAY_EVENT_GROUPS_API.CREATE_EVENT_GROUP

1211: l_grade_flag := 'TRUE';
1212: -- a) Step a
1213:
1214: -- PAY_DATETRACKED_EVENTS_API. CREATE_DATETRACKED_EVENT
1215: -- PAY_EVENT_GROUPS_API.CREATE_EVENT_GROUP
1216:
1217: l_count := 0;
1218:
1219: SELECT COUNT(*)

Line 1221: FROM pay_event_groups

1217: l_count := 0;
1218:
1219: SELECT COUNT(*)
1220: INTO l_count
1221: FROM pay_event_groups
1222: WHERE event_group_name = UPPER(l_modified_base_pg || ' PAYSCALE pg');
1223:
1224: IF (l_count = 0) THEN
1225: hr_utility.trace('If condition ...creating event group');

Line 1226: pay_event_groups_api.create_event_group

1222: WHERE event_group_name = UPPER(l_modified_base_pg || ' PAYSCALE pg');
1223:
1224: IF (l_count = 0) THEN
1225: hr_utility.trace('If condition ...creating event group');
1226: pay_event_groups_api.create_event_group
1227: (
1228: p_effective_date => TO_DATE(l_date,'dd/mm/yyyy')
1229: ,p_event_group_name => UPPER(l_modified_base_pg || ' payscale pg' )
1230: ,p_event_group_type => 'P'

Line 1243: -- FROM pay_event_groups

1239: l_event_group_id := NULL;
1240:
1241: -- SELECT event_group_id
1242: -- INTO l_event_group_id
1243: -- FROM pay_event_groups
1244: -- WHERE event_group_name = UPPER(l_modified_base_pg ||
1245: -- ' payscale pg');
1246: FOR cegi3 IN c_event_group_id(UPPER(l_modified_base_pg || ' payscale pg'))
1247: LOOP

Line 1643: -- PAY_EVENT_GROUPS_API.CREATE_EVENT_GROUP

1639:
1640: -- a) Step a
1641:
1642: -- PAY_DATETRACKED_EVENTS_API. CREATE_DATETRACKED_EVENT
1643: -- PAY_EVENT_GROUPS_API.CREATE_EVENT_GROUP
1644:
1645: l_count := 0;
1646:
1647: SELECT COUNT(*)

Line 1649: FROM pay_event_groups

1645: l_count := 0;
1646:
1647: SELECT COUNT(*)
1648: INTO l_count
1649: FROM pay_event_groups
1650: WHERE event_group_name = l_pg_name;
1651:
1652: IF (l_count = 0) THEN
1653: hr_utility.trace('If condition ... Creating event groups');

Line 1654: pay_event_groups_api.create_event_group

1650: WHERE event_group_name = l_pg_name;
1651:
1652: IF (l_count = 0) THEN
1653: hr_utility.trace('If condition ... Creating event groups');
1654: pay_event_groups_api.create_event_group
1655: (
1656: p_effective_date => TO_DATE(p_pg_startdate,'dd/mm/yyyy')
1657: ,p_event_group_name => l_pg_name
1658: ,p_event_group_type => 'P'

Line 1671: -- FROM pay_event_groups

1667: l_event_group_id := NULL;
1668:
1669: -- SELECT event_group_id
1670: -- INTO l_event_group_id
1671: -- FROM pay_event_groups
1672: -- WHERE event_group_name = l_pg_name;
1673:
1674: FOR cegid IN c_event_group_id (l_pg_name)
1675: LOOP

Line 1981: -- FROM pay_event_groups

1977: l_pg_name := UPPER(SUBSTR(REPLACE(p_ele_pg, ' ',' '), 1, 40));
1978:
1979: -- SELECT event_group_id
1980: -- INTO l_pg_id
1981: -- FROM pay_event_groups
1982: -- WHERE UPPER(event_group_name) = l_pg_name;
1983:
1984: FOR cegid IN c_event_group_id (l_pg_name)
1985: LOOP