[Home] [Help]
322: g_asg_creation_cache_populated BOOLEAN := FALSE;
323: g_asg_process_cache_populated BOOLEAN := FALSE;
324: g_fnd_rep_request_msg VARCHAR2(2000):=' ';
325: -- SRS Params
326: g_payroll_id pay_payrolls_f.payroll_id%TYPE;
327: g_start_date DATE;
328: g_effective_date DATE;
329: g_end_date DATE;
330: g_business_group_id hr_organization_units.business_group_id%TYPE;
1223: select oi.ORG_INFORMATION3,
1224: oi.ORG_INFORMATION4,
1225: ass.ASSIGNMENT_ID
1226: from hr_organization_information oi,
1227: pay_payrolls_f roll,
1228: hr_soft_coding_keyflex flex,
1229: per_assignments_f ass,
1230: fnd_sessions sess
1231: where oi.ORG_INFORMATION_CONTEXT = 'Tax Details References'
3234: cursor csr_week_or_month(p_payroll_action_id NUMBER) IS
3235: SELECT decode(target.basic_period_type, 'W', 'W', 'M')
3236: FROM per_time_period_rules target ,
3237: per_time_period_types ptpt ,
3238: pay_payrolls_f roll,
3239: pay_payroll_actions pact
3240: WHERE ptpt.period_type = roll.period_type
3241: AND target.number_per_fiscal_year = ptpt.number_per_fiscal_year
3242: AND roll.payroll_id = pact.payroll_id
3248: cursor week_month_by_paroll_id (p_payroll_id NUMBER , p_effective_date date) IS
3249: SELECT decode(target.basic_period_type, 'W', 'W', 'M')
3250: FROM per_time_period_rules target ,
3251: per_time_period_types ptpt ,
3252: pay_payrolls_f roll
3253: WHERE ptpt.period_type = roll.period_type
3254: AND target.number_per_fiscal_year = ptpt.number_per_fiscal_year
3255: AND roll.payroll_id = p_payroll_id
3256: AND p_effective_date BETWEEN roll.effective_start_date