DBA Data[Home] [Help]

APPS.PAY_EXA_SHD dependencies on PAY_LEGISLATION_RULES

Line 420: FROM PAY_LEGISLATION_RULES plr,

416: -- for the specified business group
417: --
418: cursor csr_id_flex_num is
419: SELECT fnd_number.canonical_to_number(plr.rule_mode)
420: FROM PAY_LEGISLATION_RULES plr,
421: PER_BUSINESS_GROUPS pbg
422: WHERE plr.rule_type = 'E'
423: and p_territory_code is null
424: and plr.legislation_code = pbg.legislation_code

Line 428: FROM PAY_LEGISLATION_RULES plr

424: and plr.legislation_code = pbg.legislation_code
425: and pbg.business_group_id = p_business_group_id
426: Union
427: SELECT fnd_number.canonical_to_number(plr.rule_mode)
428: FROM PAY_LEGISLATION_RULES plr
429: WHERE plr.rule_type = 'E'
430: and p_territory_code is not null
431: and plr.legislation_code = p_territory_code;
432: