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 925: AND ( grant_date BETWEEN ( SELECT START_DATE FROM ben_tcs_stmt_perd

921: ben_cwb_stock_optn_dtls
922: WHERE ( person_id = v_person_id
923: OR (business_group_id = v_business_group
924: AND employee_number = p_emp_num) )
925: AND ( grant_date BETWEEN ( SELECT START_DATE FROM ben_tcs_stmt_perd
926: WHERE stmt_perd_id = v_stmt_perd_id )
927: AND v_period_end_date );
928:
929: stk_opts_rec c_stk_opts%ROWTYPE ;

Line 2236: FROM ben_tcs_stmt stmt , ben_tcs_stmt_perd period

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

Line 2248: FROM ben_tcs_stmt stmt , ben_tcs_stmt_perd period

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

Line 2407: FROM ben_tcs_stmt_perd

2403:
2404: SELECT start_date , end_date
2405: INTO l_period_start_date,
2406: l_actual_end_date
2407: FROM ben_tcs_stmt_perd
2408: WHERE stmt_perd_id = p_period_id ;
2409:
2410: WRITE ('=====================process====================');
2411: WRITE ('||Parameter Description ');