APPS.PAY_BALANCE_UPLOAD dependencies on PAY_LEGISLATION_RULES

Line 321: ,include_adj_rule pay_legislation_rules.rule_mode%type

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

Line 761: g_leg_rule pay_legislation_rules.rule_mode%type;

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

Line 809: from pay_legislation_rules plr,

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

Line 5280: from pay_legislation_rules

5276: --
5277: begin
5278: select nvl(rule_mode, 'N')
5279: into l_validation_supp
5280: from pay_legislation_rules
5281: where legislation_code = p_glbl_data_rec.legislation_code
5282: and rule_type = 'BAL_INIT_VALIDATION';
5283: exception
5284: when no_data_found then