DBA Data[Home] [Help]

APPS.PAY_IN_BAL_UPL_STRUCT dependencies on PAY_LEGISLATION_RULES

Line 406: l_leg_code pay_legislation_rules.legislation_code%TYPE;

402: l_source_text_iv number(2) := 0;
403: l_source_text_iv_val VARCHAR2(30);
404: l_source_text2_iv number(2) := 0;
405: l_source_text2_iv_val VARCHAR2(30);
406: l_leg_code pay_legislation_rules.legislation_code%TYPE;
407: l_seq_number NUMBER(2);
408: l_no_input_values NUMBER(10);
409:
410: l_message VARCHAR2(255);

Line 441: FROM pay_legislation_rules

437:
438: CURSOR csr_rule1 (p_leg_code IN VARCHAR2)
439: IS
440: SELECT 1, rule_mode
441: FROM pay_legislation_rules
442: WHERE rule_type ='SOURCE_IV'
443: AND legislation_code = p_leg_code;
444:
445: CURSOR csr_rule2 (p_leg_code IN VARCHAR2)

Line 448: FROM pay_legislation_rules

444:
445: CURSOR csr_rule2 (p_leg_code IN VARCHAR2)
446: IS
447: SELECT 1, rule_mode
448: FROM pay_legislation_rules
449: WHERE rule_type ='SOURCE_TEXT_IV'
450: AND legislation_code = p_leg_code;
451:
452: CURSOR csr_rule3 (p_leg_code IN VARCHAR2)