DBA Data[Home] [Help]

APPS.PAY_IP_UTILITY dependencies on HR_LEGISLATION_INSTALLATIONS

Line 27: hr_legislation_installations hli

23:
24: cursor c_ip_installed (cp_business_grp_id NUMBER) is
25: select 'Y'
26: from per_business_groups pbg,
27: hr_legislation_installations hli
28: where business_group_id = cp_business_grp_id
29: and pbg.legislation_code = hli.legislation_code;
30:
31: lv_leg_installed VARCHAR2(10) := 'N';

Line 51: FROM hr_legislation_installations hli

47: RETURN VARCHAR2 IS
48:
49: CURSOR c_ip_installed (cp_legislation_code VARCHAR2) is
50: SELECT 'Y'
51: FROM hr_legislation_installations hli
52: WHERE hli.legislation_code =cp_legislation_code
53: AND APPLICATION_SHORT_NAME ='PAY'
54: AND STATUS='I';
55: