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

Line 1194: v_rule_mode pay_legislation_rules.rule_mode%type;

1190: v_time_period_id per_time_periods.time_period_id%TYPE;
1191: v_time_period_name per_time_periods.period_name%TYPE;
1192: v_proc varchar2(72) := g_package||'chk_date_earned';
1193: v_argument varchar2(30);
1194: v_rule_mode pay_legislation_rules.rule_mode%type;
1195: --
1196: cursor sel_pay is
1197: select asg.payroll_id
1198: from per_assignments_f asg

Line 1207: from pay_legislation_rules

1203: and asg.effective_end_date;
1204: --
1205: cursor get_leg_rule is
1206: select rule_mode
1207: from pay_legislation_rules
1208: where rule_type = 'ENABLE_QP_OFFSET'
1209: and legislation_code = p_legislation_code;
1210: --
1211: begin