[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
2177: select TPT.number_per_fiscal_year
2178: into v_periods_per_fiscal_yr
2179: from pay_payrolls_f PPF,
2180: per_time_period_types TPT,
2181: fnd_sessions fs
2182: where PPF.payroll_id = p_payroll
2183: and fs.session_id = USERENV('SESSIONID')
2184: and fs.effective_date between PPF.effective_start_date and PPF.effective_end_date
2185: and TPT.period_type = PPF.period_type;
2200: SELECT TPT.number_per_fiscal_year
2201: INTO v_annualizing_factor
2202: FROM pay_payrolls_f PRL,
2203: per_time_period_types TPT,
2204: fnd_sessions fs
2205: WHERE TPT.period_type = PRL.period_type
2206: and fs.session_id = USERENV('SESSIONID')
2207: and fs.effective_date BETWEEN PRL.effective_start_date
2208: AND PRL.effective_end_date
2253: SELECT TPT.number_per_fiscal_year
2254: INTO v_annualizing_factor
2255: FROM pay_payrolls_f PRL,
2256: per_time_period_types TPT,
2257: fnd_sessions fs
2258: WHERE TPT.period_type = PRL.period_type
2259: and fs.session_id = USERENV('SESSIONID')
2260: and fs.effective_date BETWEEN PRL.effective_start_date
2261: AND PRL.effective_end_date
2366: select TPT.number_per_fiscal_year
2367: into v_periods_per_fiscal_yr
2368: from pay_payrolls_f PPF,
2369: per_time_period_types TPT,
2370: fnd_sessions fs
2371: where PPF.payroll_id = p_payroll
2372: and fs.session_id = USERENV('SESSIONID')
2373: and fs.effective_date between PPF.effective_start_date and PPF.effective_end_date
2374: and TPT.period_type = PPF.period_type;
2511: -- hr_utility.raise_error;
2512: --
2513: END IF;
2514: --
2515: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this
2516: -- record if one doe not already exist.
2517: --
2518: SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')
2519: INTO v_fnd_sess_row
2516: -- record if one doe not already exist.
2517: --
2518: SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')
2519: INTO v_fnd_sess_row
2520: FROM fnd_sessions
2521: WHERE session_id = userenv('sessionid');
2522: --
2523: IF v_fnd_sess_row = 'N' THEN
2524: --
2522: --
2523: IF v_fnd_sess_row = 'N' THEN
2524: --
2525: dt_fndate.set_effective_date (p_effective_date => sysdate);
2526: -- INSERT INTO fnd_sessions
2527: -- SELECT userenv('sessionid'),
2528: -- sysdate
2529: -- FROM sys.dual;
2530: --