[Home] [Help]
264: to shield our code from future
265: FND_SESSION table changes.
266: 07-FEB-2002 tclewis 115.26 Modified the code around dt_fndate
267: above to first check for the
268: existence of a row in the FND_Sessions
269: table before making the call.
270: 13-FEB-2002 rsirigir 115.27 Bug 2196352
271: changed datatype/datalengths
272: for three variables
310: to nvl(p_period_start_date, sysdate).
311: 19-NOV-2002 tclewis 115.32 Fixed GSCC compliance warning with
312: default parameter values.
313: 19-nov-2002 tclewis 115.33 changed nvl(p_period_start_date, sysdate)
314: to use fnd_sessions.
315: 07-Jan-2003 ekim 115.35 Made performance change in function
316: OT_Base_Rate as :
317: Added date joins and business_group_id
318: and legislation_code join. Also added
339: looks for a salary element starting
340: in the
341: middle of the pay period.
342: 25-Jul-2003 vmehta 115.39 Modified get_annulization_factor (within
343: convert_period_type) to use fnd_sessions
344: to get the effective date instead of
345: using p_effecive_end_date. (Bug 3067262)
346: 07-JAN-2004 trugless 115.40 Commented out the following code for bug
347: 3271413 in the SELECT (ASG1.2) section
2486: select TPT.number_per_fiscal_year
2487: into v_periods_per_fiscal_yr
2488: from pay_payrolls_f PPF,
2489: per_time_period_types TPT,
2490: fnd_sessions fs
2491: where PPF.payroll_id = p_payroll
2492: and fs.session_id = USERENV('SESSIONID')
2493: and fs.effective_date between PPF.effective_start_date and PPF.effective_end_date
2494: and TPT.period_type = PPF.period_type;
2508: SELECT TPT.number_per_fiscal_year
2509: INTO v_annualizing_factor
2510: FROM pay_payrolls_f PRL,
2511: per_time_period_types TPT,
2512: fnd_sessions fs
2513: WHERE TPT.period_type = PRL.period_type
2514: and fs.session_id = USERENV('SESSIONID')
2515: and fs.effective_date BETWEEN PRL.effective_start_date
2516: AND PRL.effective_end_date
2562: SELECT TPT.number_per_fiscal_year
2563: INTO v_annualizing_factor
2564: FROM pay_payrolls_f PRL,
2565: per_time_period_types TPT,
2566: fnd_sessions fs
2567: WHERE TPT.period_type = PRL.period_type
2568: and fs.session_id = USERENV('SESSIONID')
2569: and fs.effective_date BETWEEN PRL.effective_start_date
2570: AND PRL.effective_end_date
2660: select TPT.number_per_fiscal_year
2661: into v_periods_per_fiscal_yr
2662: from pay_payrolls_f PPF,
2663: per_time_period_types TPT,
2664: fnd_sessions fs
2665: where PPF.payroll_id = p_payroll
2666: and fs.session_id = USERENV('SESSIONID')
2667: and fs.effective_date between PPF.effective_start_date and PPF.effective_end_date
2668: and TPT.period_type = PPF.period_type;
2901: -- hr_utility.raise_error;
2902: --
2903: END IF;
2904: --
2905: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this
2906: -- record if one doe not already exist.
2907: --
2908: SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')
2909: INTO v_fnd_sess_row
2906: -- record if one doe not already exist.
2907: --
2908: SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')
2909: INTO v_fnd_sess_row
2910: FROM fnd_sessions
2911: WHERE session_id = userenv('sessionid');
2912: --
2913: IF v_fnd_sess_row = 'N' THEN
2914: