DBA Data[Home] [Help]

APPS.PQP_PRORATION_WRAPPER dependencies on PAY_FUNCTIONAL_AREAS

Line 142: FROM pay_functional_areas

138: c_dtc c_dt_cursor;
139:
140: CURSOR c_functional_areas IS
141: SELECT area_id
142: FROM pay_functional_areas
143: WHERE short_name = 'INCIDENT REGISTER';
144:
145: CURSOR c_functional_usages(p_area_id IN NUMBER ,
146: p_business_group_Id IN NUMBER ) IS

Line 164: FROM pay_functional_areas pfa,

160: l_location_flag := p_location_flag ;
161:
162: l_select_statement := 'SELECT pte.short_name,
163: pte.event_id
164: FROM pay_functional_areas pfa,
165: pay_functional_triggers pft,
166: pay_trigger_events pte
167: WHERE pte.event_id = pft.event_id
168: AND pft.area_id = pfa.area_id