DBA Data[Home] [Help]

APPS.PQH_ACC_BUS dependencies on PQH_ACCOMMODATIONS_F

Line 30: , pqh_accommodations_f acc

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pqh_accommodations_f acc
31: where acc.accommodation_id = p_accommodation_id
32: and pbg.business_group_id = acc.business_group_id;
33: --
34: -- Declare local variables

Line 94: , pqh_accommodations_f acc

90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , pqh_accommodations_f acc
95: where acc.accommodation_id = p_accommodation_id
96: and pbg.business_group_id = acc.business_group_id;
97: --
98: -- Declare local variables

Line 753: from pqh_accommodations_f

749: IS
750: --
751: Cursor csr_unique_name is
752: Select null
753: from pqh_accommodations_f
754: where accommodation_name = p_accommodation_name
755: and business_group_id = p_business_group_id;
756: --
757: l_value varchar2(10);

Line 779: from pqh_accommodations_f

775: IS
776: --
777: Cursor csr_unique_name is
778: Select null
779: from pqh_accommodations_f
780: where accommodation_name = p_accommodation_name
781: and business_group_id = p_business_group_id
782: and accommodation_id <> p_accommodation_id;
783: --