DBA Data[Home] [Help]

APPS.PAY_P45_PKG dependencies on PER_TIME_PERIOD_TYPES

Line 2871: per_time_period_types ptpt ,

2867: --
2868: cursor csr_week_or_month(p_payroll_action_id NUMBER) IS
2869: SELECT decode(target.basic_period_type, 'W', 'W', 'M')
2870: FROM per_time_period_rules target ,
2871: per_time_period_types ptpt ,
2872: pay_payrolls_f roll,
2873: pay_payroll_actions pact
2874: WHERE ptpt.period_type = roll.period_type
2875: AND target.number_per_fiscal_year = ptpt.number_per_fiscal_year