APPS.HRDYNDBI dependencies on PAY_LEGISLATION_RULES

Line 7549: from pay_legislation_rules

7545: -- declare cursor 1 for retrieving each legislation using this flex num
7546: --
7547: cursor c1 is
7548: select legislation_code
7549: from pay_legislation_rules
7550: where rule_type = 'E'
7551: and rule_mode = to_char (p_id_flex_num);
7552: --
7553: l_legislation_code pay_legislation_rules.legislation_code%type;

Line 7553: l_legislation_code pay_legislation_rules.legislation_code%type;

7549: from pay_legislation_rules
7550: where rule_type = 'E'
7551: and rule_mode = to_char (p_id_flex_num);
7552: --
7553: l_legislation_code pay_legislation_rules.legislation_code%type;
7554: l_route_name varchar2(50) := 'EXT_ACCOUNT_ORG_KEYFLEX_ROUTE';
7555: --
7556: ----------------------- create_ext_acc_keyflex_dict -------------------------
7557: --

Line 7648: from pay_legislation_rules

7644: -- declare cursor 0 for retrieving each legislation using this flex num
7645: --
7646: cursor c0 is
7647: select legislation_code
7648: from pay_legislation_rules
7649: where rule_type = 'S'
7650: and rule_mode = to_char (p_id_flex_num);
7651: l_created_by number;
7652: l_last_login number;

Line 7653: l_legislation_code pay_legislation_rules.legislation_code%type;

7649: where rule_type = 'S'
7650: and rule_mode = to_char (p_id_flex_num);
7651: l_created_by number;
7652: l_last_login number;
7653: l_legislation_code pay_legislation_rules.legislation_code%type;
7654: --
7655: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
7656: -- create_scl_flex +
7657: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Line 10081: from pay_legislation_rules plr

10077: -- Cursor to fetch information on legislations that support translations.
10078: --
10079: cursor csr_fetch_legs is
10080: select plr.legislation_code
10081: from pay_legislation_rules plr
10082: where rule_type = 'FF_TRANSLATE_DATABASE_ITEMS'
10083: and rule_mode = 'Y'
10084: ;
10085: --