DBA Data[Home] [Help]

APPS.PAY_QPQ_API dependencies on PAY_LEGISLATION_RULES

Line 992: v_rule_mode pay_legislation_rules.rule_mode%type;

988: v_eff_time_period_id per_time_periods.time_period_id%TYPE;
989: v_eff_time_period_name per_time_periods.period_name%TYPE;
990: v_new_date_earned pay_payroll_actions.date_earned%TYPE;
991: v_proc varchar2(72) := g_package||'chk_eff_date';
992: v_rule_mode pay_legislation_rules.rule_mode%type;
993: --
994: -- Used to find out if the assingment is on a payroll as p_effective_date
995: --
996: cursor sel_pay is

Line 1007: from pay_legislation_rules

1003: and asg.effective_end_date;
1004: --
1005: cursor get_leg_rule is
1006: select rule_mode
1007: from pay_legislation_rules
1008: where rule_type = 'ENABLE_QP_OFFSET'
1009: and legislation_code = p_legislation_code;
1010: --
1011: begin