DBA Data[Home] [Help]

APPS.PAY_P45_PKG dependencies on PER_TIME_PERIOD_RULES

Line 3236: FROM per_time_period_rules target ,

3232: AND p.effective_end_date;
3233: --
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

Line 3250: FROM per_time_period_rules target ,

3246: --
3247: -- Bug 8464343 : fetch week month type by 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