[Home] [Help]
23: for Bug No: 1081235
24: v_pay_basis_code,
25: v_asst_std_freq_code
26: 17-SEP-2001 SSouresr Changed the insert into the
27: table fnd_sessions to use the
28: function set_effective_date
29: instead.
30: 10-Jan-2002 vpandya Converted p_tax_unit_id to
31: character while comparing it
2140: select TPT.number_per_fiscal_year
2141: into v_periods_per_fiscal_yr
2142: from pay_payrolls_f PPF,
2143: per_time_period_types TPT,
2144: fnd_sessions fs
2145: where PPF.payroll_id = p_payroll
2146: and fs.session_id = USERENV('SESSIONID')
2147: and fs.effective_date between PPF.effective_start_date and PPF.effective_end_date
2148: and TPT.period_type = PPF.period_type;
2163: SELECT TPT.number_per_fiscal_year
2164: INTO v_annualizing_factor
2165: FROM pay_payrolls_f PRL,
2166: per_time_period_types TPT,
2167: fnd_sessions fs
2168: WHERE TPT.period_type = PRL.period_type
2169: and fs.session_id = USERENV('SESSIONID')
2170: and fs.effective_date BETWEEN PRL.effective_start_date
2171: AND PRL.effective_end_date
2216: SELECT TPT.number_per_fiscal_year
2217: INTO v_annualizing_factor
2218: FROM pay_payrolls_f PRL,
2219: per_time_period_types TPT,
2220: fnd_sessions fs
2221: WHERE TPT.period_type = PRL.period_type
2222: and fs.session_id = USERENV('SESSIONID')
2223: and fs.effective_date BETWEEN PRL.effective_start_date
2224: AND PRL.effective_end_date
2329: select TPT.number_per_fiscal_year
2330: into v_periods_per_fiscal_yr
2331: from pay_payrolls_f PPF,
2332: per_time_period_types TPT,
2333: fnd_sessions fs
2334: where PPF.payroll_id = p_payroll
2335: and fs.session_id = USERENV('SESSIONID')
2336: and fs.effective_date between PPF.effective_start_date and PPF.effective_end_date
2337: and TPT.period_type = PPF.period_type;
2474: -- hr_utility.raise_error;
2475: --
2476: END IF;
2477: --
2478: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this
2479: -- record if one doe not already exist.
2480: --
2481: SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')
2482: INTO v_fnd_sess_row
2479: -- record if one doe not already exist.
2480: --
2481: SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')
2482: INTO v_fnd_sess_row
2483: FROM fnd_sessions
2484: WHERE session_id = userenv('sessionid');
2485: --
2486: IF v_fnd_sess_row = 'N' THEN
2487: --
2485: --
2486: IF v_fnd_sess_row = 'N' THEN
2487: --
2488: dt_fndate.set_effective_date (p_effective_date => sysdate);
2489: -- INSERT INTO fnd_sessions
2490: -- SELECT userenv('sessionid'),
2491: -- sysdate
2492: -- FROM sys.dual;
2493: --