APPS.HRDYNDBI dependencies on PAY_LEGISLATION_RULES

Line 7626: from pay_legislation_rules

7622: -- declare cursor 1 for retrieving each legislation using this flex num
7623: --
7624: cursor c1 is
7625: select legislation_code
7626: from pay_legislation_rules
7627: where rule_type = 'E'
7628: and rule_mode = to_char (p_id_flex_num);
7629: --
7630: l_legislation_code pay_legislation_rules.legislation_code%type;

Line 7630: l_legislation_code pay_legislation_rules.legislation_code%type;

7626: from pay_legislation_rules
7627: where rule_type = 'E'
7628: and rule_mode = to_char (p_id_flex_num);
7629: --
7630: l_legislation_code pay_legislation_rules.legislation_code%type;
7631: l_route_name varchar2(50) := 'EXT_ACCOUNT_ORG_KEYFLEX_ROUTE';
7632: --
7633: ----------------------- create_ext_acc_keyflex_dict -------------------------
7634: --

Line 7725: from pay_legislation_rules

7721: -- declare cursor 0 for retrieving each legislation using this flex num
7722: --
7723: cursor c0 is
7724: select legislation_code
7725: from pay_legislation_rules
7726: where rule_type = 'S'
7727: and rule_mode = to_char (p_id_flex_num);
7728: l_created_by number;
7729: l_last_login number;

Line 7730: l_legislation_code pay_legislation_rules.legislation_code%type;

7726: where rule_type = 'S'
7727: and rule_mode = to_char (p_id_flex_num);
7728: l_created_by number;
7729: l_last_login number;
7730: l_legislation_code pay_legislation_rules.legislation_code%type;
7731: --
7732: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
7733: -- create_scl_flex +
7734: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Line 10158: from pay_legislation_rules plr

10154: -- Cursor to fetch information on legislations that support translations.
10155: --
10156: cursor csr_fetch_legs is
10157: select plr.legislation_code
10158: from pay_legislation_rules plr
10159: where rule_type = 'FF_TRANSLATE_DATABASE_ITEMS'
10160: and rule_mode = 'Y'
10161: ;
10162: --