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.BEN_TCS_STMT_PROCESS dependencies on BEN_TCS_PER_STMT_PERD

Line 77: FROM ben_tcs_per_stmt_perd per_perd, ben_tcs_stmt_perd perd

73: p_period_end_date IN DATE,
74: p_stmt_id IN NUMBER)
75: IS
76: SELECT per_perd.stmt_id
77: FROM ben_tcs_per_stmt_perd per_perd, ben_tcs_stmt_perd perd
78: WHERE per_perd.stmt_id <> p_stmt_id
79: AND per_perd.person_id = p_person_id
80: AND per_perd.end_date = p_period_end_date
81: AND perd.stmt_perd_id = per_perd.stmt_perd_id

Line 323: FROM ben_tcs_per_stmt_perd

319:
320: CURSOR c_stmt_period (v_stmt_id IN NUMBER , v_perd_id IN NUMBER )
321: IS
322: SELECT stmt_id ,stmt_perd_id
323: FROM ben_tcs_per_stmt_perd
324: WHERE stmt_id = v_stmt_id
325: AND stmt_perd_id = v_perd_id;
326: stmt_perd_rec c_stmt_period%ROWTYPE;
327:

Line 331: FROM ben_tcs_per_stmt_perd

327:
328: CURSOR c_per_stmt_period (v_perd_id IN NUMBER)
329: IS
330: SELECT stmt_perd_id
331: FROM ben_tcs_per_stmt_perd
332: WHERE stmt_perd_id = v_perd_id ;
333:
334: CURSOR c_per_stmt (v_stmt_id IN NUMBER)
335: IS

Line 337: FROM ben_tcs_per_stmt_perd

333:
334: CURSOR c_per_stmt (v_stmt_id IN NUMBER)
335: IS
336: SELECT stmt_id
337: FROM ben_tcs_per_stmt_perd
338: WHERE stmt_id = v_stmt_id ;
339:
340: CURSOR c_item_hrchy_val(v_period_id IN NUMBER)
341: IS

Line 785: FROM ben_tcs_per_stmt_perd

781: SAVEPOINT Purge ;
782:
783: SELECT per_stmt_perd_id
784: INTO l_per_stmt_perd
785: FROM ben_tcs_per_stmt_perd
786: WHERE
787: stmt_id = p_stmt_id
788: AND stmt_perd_id = p_stmt_perd_id
789: AND person_id = p_person_id ;

Line 794: FROM ben_tcs_per_stmt_perd

790:
791: hr_utility.set_location ( 'delete per_stmt_perd_id entry for per_stmt_perd_id :' || l_per_stmt_perd,72);
792:
793: DELETE
794: FROM ben_tcs_per_stmt_perd
795: WHERE per_stmt_perd_id = l_per_stmt_perd;
796:
797: OPEN c_asg_stmt( l_per_stmt_perd);
798: LOOP

Line 1054: hr_utility.set_location('inserting INTO ben_tcs_per_stmt_perd person id , period id , stmt id '||

1050: FOR i IN 1..l_result.count
1051: LOOP
1052: IF (i =1 ) THEN
1053: IF l_count = 0 AND gen = 0 THEN
1054: hr_utility.set_location('inserting INTO ben_tcs_per_stmt_perd person id , period id , stmt id '||
1055: p_person_id|| p_stmt_perd_id||p_stmt_id,87);
1056:
1057: l_person_inc := 1;
1058: l_count := l_count + 1;

Line 1060: INSERT INTO ben_tcs_per_stmt_perd

1056:
1057: l_person_inc := 1;
1058: l_count := l_count + 1;
1059:
1060: INSERT INTO ben_tcs_per_stmt_perd
1061: ( per_stmt_perd_id ,
1062: stmt_id ,
1063: stmt_perd_id,
1064: person_id,

Line 1068: ( ben_tcs_per_stmt_perd_s.NEXTVAL ,

1064: person_id,
1065: show_wlcm_pg_flag,
1066: end_date )
1067: VALUES
1068: ( ben_tcs_per_stmt_perd_s.NEXTVAL ,
1069: p_stmt_id,
1070: p_stmt_perd_id,
1071: p_person_id,
1072: null,

Line 1077: hr_utility.set_location('After inserting INTO ben_tcs_per_stmt_perd ',88);

1073: p_period_end_date);
1074:
1075: person_created_now := 'Y';
1076:
1077: hr_utility.set_location('After inserting INTO ben_tcs_per_stmt_perd ',88);
1078:
1079: END IF;
1080:
1081: IF gen = 0 THEN

Line 1094: ben_tcs_per_stmt_perd_s.CURRVAL,

1090: VALUES
1091: ( ben_tcs_asg_stmt_s.NEXTVAL ,
1092: p_stmt_id,
1093: l_assign.assignment_id,
1094: ben_tcs_per_stmt_perd_s.CURRVAL,
1095: l_assign.assignment_number);
1096:
1097: hr_utility.set_location('After inserting INTO ben_tcs_asg_stmt ',90);
1098: IF (Record_Created ='N') THEN

Line 1449: hr_utility.set_location('inserting INTO ben_tcs_per_stmt_perd person id , period id , stmt id '||

1445: IF ( stk_opts_rec.total IS NOT NULL ) THEN
1446: hr_utility.set_location('Person has value for stock options extended subcategory',95);
1447: cntr_item := 'Y';
1448: IF l_count = 0 AND gen = 0 THEN
1449: hr_utility.set_location('inserting INTO ben_tcs_per_stmt_perd person id , period id , stmt id '||
1450: p_person_id|| p_stmt_perd_id||p_stmt_id ||' subcategory part' ,96);
1451:
1452: l_person_inc := 1;
1453: l_count := l_count + 1;

Line 1455: INSERT INTO ben_tcs_per_stmt_perd

1451:
1452: l_person_inc := 1;
1453: l_count := l_count + 1;
1454:
1455: INSERT INTO ben_tcs_per_stmt_perd
1456: ( per_stmt_perd_id ,
1457: stmt_id ,
1458: stmt_perd_id,
1459: person_id,

Line 1463: ( ben_tcs_per_stmt_perd_s.NEXTVAL ,

1459: person_id,
1460: show_wlcm_pg_flag,
1461: end_date )
1462: VALUES
1463: ( ben_tcs_per_stmt_perd_s.NEXTVAL ,
1464: p_stmt_id,
1465: p_stmt_perd_id,
1466: p_person_id,
1467: null,

Line 1470: hr_utility.set_location('After inserting INTO ben_tcs_per_stmt_perd ',97);

1466: p_person_id,
1467: null,
1468: p_period_end_date);
1469:
1470: hr_utility.set_location('After inserting INTO ben_tcs_per_stmt_perd ',97);
1471: END IF;
1472:
1473: IF gen = 0 THEN
1474:

Line 1486: ben_tcs_per_stmt_perd_s.CURRVAL,

1482: VALUES
1483: ( ben_tcs_asg_stmt_s.NEXTVAL ,
1484: p_stmt_id,
1485: l_assign.assignment_id,
1486: ben_tcs_per_stmt_perd_s.CURRVAL,
1487: l_assign.assignment_number);
1488:
1489: hr_utility.set_location('After inserting INTO ben_tcs_asg_stmt ',99);
1490: IF (Record_Created ='N') THEN

Line 1661: g_actn := 'updating ben_tcs_per_stmt_perd' ;

1657: BEGIN
1658:
1659: g_proc := 'set_wlcm_flag';
1660: hr_utility.set_location('Entering '||g_proc,106);
1661: g_actn := 'updating ben_tcs_per_stmt_perd' ;
1662:
1663: WRITE ('In Procedure' ||g_proc);
1664: WRITE ('===========Reset welcome flag for the person============');
1665: WRITE ('||Person Id ' || p_person_id);

Line 1678: FROM ben_tcs_per_stmt_perd

1674: || 'person id :' ||p_person_id,107);
1675:
1676: SELECT show_wlcm_pg_flag
1677: INTO wlcm_flag
1678: FROM ben_tcs_per_stmt_perd
1679: WHERE stmt_id = p_stmt_id
1680: AND stmt_perd_id = p_stmt_perd_id
1681: AND person_id = p_person_id ;
1682:

Line 1706: UPDATE ben_tcs_per_stmt_perd

1702: l_rep_rec(rep_count ).EMPLOYEE_NUMBER := p_emp_num;
1703: l_rep_rec(rep_count ).FULL_NAME := p_emp_name;
1704: l_rep_rec(rep_count ).STMT_CREATED := 'Y';
1705:
1706: UPDATE ben_tcs_per_stmt_perd
1707: SET show_wlcm_pg_flag = null
1708: WHERE stmt_id = p_stmt_id
1709: AND stmt_perd_id = p_stmt_perd_id
1710: AND person_id = p_person_id ;

Line 2311: FROM BEN_TCS_PER_STMT_PERD stmt,per_all_people_f per

2307:
2308: CURSOR c_check_stmt_person(v_person_id IN NUMBER ,v_stmt_id IN NUMBER ,v_perd_id IN NUMBER)
2309: IS
2310: SELECT stmt.person_id ,per.full_name name
2311: FROM BEN_TCS_PER_STMT_PERD stmt,per_all_people_f per
2312: WHERE stmt.stmt_id = v_stmt_id
2313: AND stmt.stmt_perd_id = v_perd_id
2314: AND stmt.person_id = v_person_id
2315: and per.person_id = stmt.person_id

Line 2323: FROM BEN_TCS_PER_STMT_PERD stmt,per_all_people_f per

2319:
2320: CURSOR c_check_stmt_avail(v_stmt_id IN NUMBER ,v_perd_id IN NUMBER)
2321: IS
2322: SELECT stmt.person_id, per.full_name name
2323: FROM BEN_TCS_PER_STMT_PERD stmt,per_all_people_f per
2324: WHERE stmt.stmt_id = v_stmt_id
2325: AND stmt.stmt_perd_id = v_perd_id
2326: AND per.person_id = stmt.person_id
2327: AND trunc(sysdate) between per.effective_start_date and per.effective_end_date;