APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_TCS_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 414: UPDATE BEN_TCS_STMT_PERD

410: END IF;
411: IF (stmt_perd_rec.stmt_perd_id IS NOT NULL ) THEN
412: --WRITE('Updating the statement generated flag .Stmt Period Id :'|| stmt_perd_rec.stmt_perd_id );
413: hr_utility.set_location('Updating the statement generated flag .Stmt Period Id : ',53);
414: UPDATE BEN_TCS_STMT_PERD
415: SET stmt_generated_flag = 'STMTGEN'
416: WHERE stmt_perd_id = stmt_perd_rec.stmt_perd_id ;
417: END IF;
418: END IF;

Line 566: UPDATE BEN_TCS_STMT_PERD

562: FETCH c_per_stmt_period
563: INTO l_perd_id ;
564: IF (c_per_stmt_period%NOTFOUND) THEN
565: hr_utility.set_location('Statement Generated Flag reset for period' || l_rep_rec(i).PERIOD_ID ,62);
566: UPDATE BEN_TCS_STMT_PERD
567: SET stmt_generated_flag = 'STMTNGEN'
568: WHERE stmt_perd_id = l_rep_rec(i).PERIOD_ID ;
569:
570: OPEN c_item_hrchy_val ( l_rep_rec(i).PERIOD_ID);

Line 917: AND ( grant_date BETWEEN ( SELECT START_DATE FROM ben_tcs_stmt_perd

913: ben_cwb_stock_optn_dtls
914: WHERE ( person_id = v_person_id
915: OR (business_group_id = v_business_group
916: AND employee_number = p_emp_num) )
917: AND ( grant_date BETWEEN ( SELECT START_DATE FROM ben_tcs_stmt_perd
918: WHERE stmt_perd_id = v_stmt_perd_id )
919: AND v_period_end_date );
920:
921: stk_opts_rec c_stk_opts%ROWTYPE ;

Line 2235: FROM ben_tcs_stmt stmt , ben_tcs_stmt_perd period

2231: CURSOR c_stmt_id_bg_id (v_stmt_name VARCHAR2, v_period_start_date IN DATE,v_period_end_date IN DATE)
2232: IS
2233: SELECT stmt.stmt_id stmt_id, period.stmt_perd_id period_id ,stmt.ee_profile_id ee_id,'Y' valid_flag,
2234: stmt.business_group_id bg_id
2235: FROM ben_tcs_stmt stmt , ben_tcs_stmt_perd period
2236: WHERE stmt.NAME = v_stmt_name
2237: AND period.start_date = v_period_start_date
2238: AND period.end_date = v_period_end_date
2239: AND period.stmt_id = stmt.stmt_id

Line 2247: FROM ben_tcs_stmt stmt , ben_tcs_stmt_perd period

2243:
2244: CURSOR c_stmt_id_bg_id1 (v_stmt_name VARCHAR2, v_period_start_date IN DATE,v_period_end_date IN DATE)
2245: IS
2246: SELECT stmt.stmt_id stmt_id, period.stmt_perd_id period_id ,stmt.business_group_id bg_id
2247: FROM ben_tcs_stmt stmt , ben_tcs_stmt_perd period
2248: WHERE stmt.NAME = v_stmt_name
2249: AND period.start_date = v_period_start_date
2250: AND period.end_date = v_period_end_date
2251: AND period.stmt_id = stmt.stmt_id;

Line 2376: FROM ben_tcs_stmt_perd

2372:
2373: SELECT start_date , end_date
2374: INTO l_period_start_date,
2375: l_actual_end_date
2376: FROM ben_tcs_stmt_perd
2377: WHERE stmt_perd_id = p_period_id ;
2378:
2379: WRITE ('=====================process====================');
2380: WRITE ('||Parameter Description ');