APPS.PAY_BALANCE_UPLOAD dependencies on PAY_LEGISLATION_RULES

Line 319: ,include_adj_rule pay_legislation_rules.rule_mode%type

315: ,batch_header_status pay_balance_batch_headers.batch_status%type
316: ,batch_line_status pay_balance_batch_lines.batch_line_status%type
317: ,chunk_size number(9)
318: ,jurisdiction_iv pay_input_values_f.name%type
319: ,include_adj_rule pay_legislation_rules.rule_mode%type
320: );
321:
322: type g_payroll_action_rec_type is record
323: (payroll_action_id pay_payroll_actions.payroll_action_id%type

Line 759: g_leg_rule pay_legislation_rules.rule_mode%type;

755: where business_group_id = p_business_group_id
756: and upper(name) = upper(p_name)
757: and p_establishment_id is null;
758: --
759: g_leg_rule pay_legislation_rules.rule_mode%type;
760: --
761: l_gre_rec csr_tax_unit%rowtype;
762: l_gre_name varchar2(80);
763: l_count NUMBER;

Line 807: from pay_legislation_rules plr,

803: begin
804: --
805: select plr.rule_mode
806: into g_leg_rule
807: from pay_legislation_rules plr,
808: per_business_groups_perf pbg
809: where pbg.business_group_id = p_business_group
810: and plr.legislation_code = pbg.legislation_code
811: and plr.rule_type = 'TAX_UNIT';

Line 4987: from pay_legislation_rules

4983: --
4984: begin
4985: select nvl(rule_mode, 'N')
4986: into l_validation_supp
4987: from pay_legislation_rules
4988: where legislation_code = p_glbl_data_rec.legislation_code
4989: and rule_type = 'BAL_INIT_VALIDATION';
4990: exception
4991: when no_data_found then