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 771: FROM ben_tcs_per_stmt_perd

767:
768: CURSOR c_per_stmt_perd
769: IS
770: SELECT per_stmt_perd_id
771: FROM ben_tcs_per_stmt_perd
772: WHERE
773: stmt_id = p_stmt_id
774: AND stmt_perd_id = p_stmt_perd_id
775: AND person_id = p_person_id ;

Line 801: FROM ben_tcs_per_stmt_perd

797:
798: hr_utility.set_location ( 'delete per_stmt_perd_id entry for per_stmt_perd_id :' || l_per_stmt_perd,72);
799:
800: DELETE
801: FROM ben_tcs_per_stmt_perd
802: WHERE per_stmt_perd_id = l_per_stmt_perd;
803:
804: OPEN c_asg_stmt( l_per_stmt_perd);
805: LOOP

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

1058: FOR i IN 1..l_result.count
1059: LOOP
1060: IF (i =1 ) THEN
1061: IF l_count = 0 AND gen = 0 THEN
1062: hr_utility.set_location('inserting INTO ben_tcs_per_stmt_perd person id , period id , stmt id '||
1063: p_person_id|| p_stmt_perd_id||p_stmt_id,87);
1064:
1065: l_person_inc := 1;
1066: l_count := l_count + 1;

Line 1068: INSERT INTO ben_tcs_per_stmt_perd

1064:
1065: l_person_inc := 1;
1066: l_count := l_count + 1;
1067:
1068: INSERT INTO ben_tcs_per_stmt_perd
1069: ( per_stmt_perd_id ,
1070: stmt_id ,
1071: stmt_perd_id,
1072: person_id,

Line 1076: ( ben_tcs_per_stmt_perd_s.NEXTVAL ,

1072: person_id,
1073: show_wlcm_pg_flag,
1074: end_date )
1075: VALUES
1076: ( ben_tcs_per_stmt_perd_s.NEXTVAL ,
1077: p_stmt_id,
1078: p_stmt_perd_id,
1079: p_person_id,
1080: null,

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

1081: p_period_end_date);
1082:
1083: person_created_now := 'Y';
1084:
1085: hr_utility.set_location('After inserting INTO ben_tcs_per_stmt_perd ',88);
1086:
1087: END IF;
1088:
1089: IF gen = 0 THEN

Line 1102: ben_tcs_per_stmt_perd_s.CURRVAL,

1098: VALUES
1099: ( ben_tcs_asg_stmt_s.NEXTVAL ,
1100: p_stmt_id,
1101: l_assign.assignment_id,
1102: ben_tcs_per_stmt_perd_s.CURRVAL,
1103: l_assign.assignment_number);
1104:
1105: hr_utility.set_location('After inserting INTO ben_tcs_asg_stmt ',90);
1106: IF (Record_Created ='N') THEN

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

1453: IF ( stk_opts_rec.total IS NOT NULL ) THEN
1454: hr_utility.set_location('Person has value for stock options extended subcategory',95);
1455: cntr_item := 'Y';
1456: IF l_count = 0 AND gen = 0 THEN
1457: hr_utility.set_location('inserting INTO ben_tcs_per_stmt_perd person id , period id , stmt id '||
1458: p_person_id|| p_stmt_perd_id||p_stmt_id ||' subcategory part' ,96);
1459:
1460: l_person_inc := 1;
1461: l_count := l_count + 1;

Line 1463: INSERT INTO ben_tcs_per_stmt_perd

1459:
1460: l_person_inc := 1;
1461: l_count := l_count + 1;
1462:
1463: INSERT INTO ben_tcs_per_stmt_perd
1464: ( per_stmt_perd_id ,
1465: stmt_id ,
1466: stmt_perd_id,
1467: person_id,

Line 1471: ( ben_tcs_per_stmt_perd_s.NEXTVAL ,

1467: person_id,
1468: show_wlcm_pg_flag,
1469: end_date )
1470: VALUES
1471: ( ben_tcs_per_stmt_perd_s.NEXTVAL ,
1472: p_stmt_id,
1473: p_stmt_perd_id,
1474: p_person_id,
1475: null,

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

1474: p_person_id,
1475: null,
1476: p_period_end_date);
1477:
1478: hr_utility.set_location('After inserting INTO ben_tcs_per_stmt_perd ',97);
1479: END IF;
1480:
1481: IF gen = 0 THEN
1482:

Line 1494: ben_tcs_per_stmt_perd_s.CURRVAL,

1490: VALUES
1491: ( ben_tcs_asg_stmt_s.NEXTVAL ,
1492: p_stmt_id,
1493: l_assign.assignment_id,
1494: ben_tcs_per_stmt_perd_s.CURRVAL,
1495: l_assign.assignment_number);
1496:
1497: hr_utility.set_location('After inserting INTO ben_tcs_asg_stmt ',99);
1498: IF (Record_Created ='N') THEN

Line 1669: g_actn := 'updating ben_tcs_per_stmt_perd' ;

1665: BEGIN
1666:
1667: g_proc := 'set_wlcm_flag';
1668: hr_utility.set_location('Entering '||g_proc,106);
1669: g_actn := 'updating ben_tcs_per_stmt_perd' ;
1670:
1671: WRITE ('In Procedure' ||g_proc);
1672: WRITE ('===========Reset welcome flag for the person============');
1673: WRITE ('||Person Id ' || p_person_id);

Line 1686: FROM ben_tcs_per_stmt_perd

1682: || 'person id :' ||p_person_id,107);
1683:
1684: SELECT show_wlcm_pg_flag
1685: INTO wlcm_flag
1686: FROM ben_tcs_per_stmt_perd
1687: WHERE stmt_id = p_stmt_id
1688: AND stmt_perd_id = p_stmt_perd_id
1689: AND person_id = p_person_id ;
1690:

Line 1714: UPDATE ben_tcs_per_stmt_perd

1710: l_rep_rec(rep_count ).EMPLOYEE_NUMBER := p_emp_num;
1711: l_rep_rec(rep_count ).FULL_NAME := p_emp_name;
1712: l_rep_rec(rep_count ).STMT_CREATED := 'Y';
1713:
1714: UPDATE ben_tcs_per_stmt_perd
1715: SET show_wlcm_pg_flag = null
1716: WHERE stmt_id = p_stmt_id
1717: AND stmt_perd_id = p_stmt_perd_id
1718: AND person_id = p_person_id ;

Line 2332: FROM BEN_TCS_PER_STMT_PERD stmt,per_all_people_f per

2328:
2329: CURSOR c_check_stmt_person(v_person_id IN NUMBER ,v_stmt_id IN NUMBER ,v_perd_id IN NUMBER)
2330: IS
2331: SELECT stmt.person_id ,per.full_name name
2332: FROM BEN_TCS_PER_STMT_PERD stmt,per_all_people_f per
2333: WHERE stmt.stmt_id = v_stmt_id
2334: AND stmt.stmt_perd_id = v_perd_id
2335: AND stmt.person_id = v_person_id
2336: and per.person_id = stmt.person_id

Line 2344: FROM BEN_TCS_PER_STMT_PERD stmt,per_all_people_f per

2340:
2341: CURSOR c_check_stmt_avail(v_stmt_id IN NUMBER ,v_perd_id IN NUMBER)
2342: IS
2343: SELECT stmt.person_id --- , per.full_name name 9702694
2344: FROM BEN_TCS_PER_STMT_PERD stmt,per_all_people_f per
2345: WHERE stmt.stmt_id = v_stmt_id
2346: AND stmt.stmt_perd_id = v_perd_id
2347: AND per.person_id = stmt.person_id
2348: AND trunc(sysdate) between per.effective_start_date and per.effective_end_date;

Line 2353: FROM BEN_TCS_PER_STMT_PERD stmt,per_all_people_f per

2349:
2350: CURSOR c_check_stmt_avail_1(v_stmt_id IN NUMBER ,v_perd_id IN NUMBER,v_person_id IN NUMBER)
2351: IS
2352: SELECT stmt.person_id --- , per.full_name name 9702694
2353: FROM BEN_TCS_PER_STMT_PERD stmt,per_all_people_f per
2354: WHERE stmt.stmt_id = v_stmt_id
2355: AND stmt.stmt_perd_id = v_perd_id
2356: AND per.person_id = stmt.person_id
2357: AND per.person_id = v_person_id