[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
2477: select TPT.number_per_fiscal_year
2478: into v_periods_per_fiscal_yr
2479: from pay_payrolls_f PPF,
2480: per_time_period_types TPT,
2481: fnd_sessions fs
2482: where PPF.payroll_id = p_payroll
2483: and fs.session_id = USERENV('SESSIONID')
2484: and fs.effective_date between PPF.effective_start_date and PPF.effective_end_date
2485: and TPT.period_type = PPF.period_type;
2499: SELECT TPT.number_per_fiscal_year
2500: INTO v_annualizing_factor
2501: FROM pay_payrolls_f PRL,
2502: per_time_period_types TPT,
2503: fnd_sessions fs
2504: WHERE TPT.period_type = PRL.period_type
2505: and fs.session_id = USERENV('SESSIONID')
2506: and fs.effective_date BETWEEN PRL.effective_start_date
2507: AND PRL.effective_end_date
2553: SELECT TPT.number_per_fiscal_year
2554: INTO v_annualizing_factor
2555: FROM pay_payrolls_f PRL,
2556: per_time_period_types TPT,
2557: fnd_sessions fs
2558: WHERE TPT.period_type = PRL.period_type
2559: and fs.session_id = USERENV('SESSIONID')
2560: and fs.effective_date BETWEEN PRL.effective_start_date
2561: AND PRL.effective_end_date
2651: select TPT.number_per_fiscal_year
2652: into v_periods_per_fiscal_yr
2653: from pay_payrolls_f PPF,
2654: per_time_period_types TPT,
2655: fnd_sessions fs
2656: where PPF.payroll_id = p_payroll
2657: and fs.session_id = USERENV('SESSIONID')
2658: and fs.effective_date between PPF.effective_start_date and PPF.effective_end_date
2659: and TPT.period_type = PPF.period_type;
2892: -- hr_utility.raise_error;
2893: --
2894: END IF;
2895: --
2896: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this
2897: -- record if one doe not already exist.
2898: --
2899: SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')
2900: INTO v_fnd_sess_row
2897: -- record if one doe not already exist.
2898: --
2899: SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')
2900: INTO v_fnd_sess_row
2901: FROM fnd_sessions
2902: WHERE session_id = userenv('sessionid');
2903: --
2904: IF v_fnd_sess_row = 'N' THEN
2905: