DBA Data[Home] [Help]

APPS.PAY_DB_PAY_US_GROSS dependencies on PER_BUSINESS_GROUPS

Line 117: per_business_groups pbg

113: processing_priority,
114: element_information10,
115: element_information12
116: FROM pay_element_types_f pet,
117: per_business_groups pbg
118: WHERE pbg.business_group_id + 0 = pet.business_group_id + 0
119: AND pbg.business_group_id + 0 = p_business_group_id
120: AND pet.element_name like v_element_name;
121: --

Line 188: FROM per_business_groups

184: -- Find the Business_group_id for the parameter
185: IF p_business_group_name is NOT NULL THEN
186: SELECT business_group_id
187: INTO g_business_group_ID
188: FROM per_business_groups
189: WHERE upper(name) = upper(p_business_group_name);
190: END IF;
191: --
192: IF p_effective_start_date IS NULL THEN