APPS.PAY_CN_BAL_UPL_STRUCT dependencies on PAY_LEGISLATION_RULES

Line 479: l_source_iv_val pay_legislation_rules.rule_mode%TYPE;

475: l_no_bal_for_jur NUMBER;
476: l_dummy_id NUMBER;
477: l_currency_code per_business_groups.currency_code%TYPE;
478: l_source_iv NUMBER(2) := 0;
479: l_source_iv_val pay_legislation_rules.rule_mode%TYPE;
480: l_source_text_iv NUMBER(2) := 0;
481: l_source_text_iv_val pay_legislation_rules.rule_mode%TYPE;
482: l_leg_code pay_legislation_rules.legislation_code%TYPE;
483: l_seq_NUMBER NUMBER(2);

Line 481: l_source_text_iv_val pay_legislation_rules.rule_mode%TYPE;

477: l_currency_code per_business_groups.currency_code%TYPE;
478: l_source_iv NUMBER(2) := 0;
479: l_source_iv_val pay_legislation_rules.rule_mode%TYPE;
480: l_source_text_iv NUMBER(2) := 0;
481: l_source_text_iv_val pay_legislation_rules.rule_mode%TYPE;
482: l_leg_code pay_legislation_rules.legislation_code%TYPE;
483: l_seq_NUMBER NUMBER(2);
484: l_no_input_values NUMBER(10) := 1;
485:

Line 482: l_leg_code pay_legislation_rules.legislation_code%TYPE;

478: l_source_iv NUMBER(2) := 0;
479: l_source_iv_val pay_legislation_rules.rule_mode%TYPE;
480: l_source_text_iv NUMBER(2) := 0;
481: l_source_text_iv_val pay_legislation_rules.rule_mode%TYPE;
482: l_leg_code pay_legislation_rules.legislation_code%TYPE;
483: l_seq_NUMBER NUMBER(2);
484: l_no_input_values NUMBER(10) := 1;
485:
486: --

Line 528: FROM pay_legislation_rules

524:
525: CURSOR csr_rule1 (p_leg_code IN VARCHAR2)
526: IS
527: SELECT 1, rule_mode
528: FROM pay_legislation_rules
529: WHERE rule_type ='SOURCE_IV'
530: AND legislation_code = p_leg_code;
531:
532: CURSOR csr_rule2 (p_leg_code IN VARCHAR2)

Line 535: FROM pay_legislation_rules

531:
532: CURSOR csr_rule2 (p_leg_code IN VARCHAR2)
533: IS
534: SELECT 1, rule_mode
535: FROM pay_legislation_rules
536: WHERE rule_type ='SOURCE_TEXT_IV'
537: AND legislation_code = p_leg_code;
538:
539: BEGIN