APPS.XLA_00240_AAD_S_000003_PKG dependencies on ALL_OBJECTS

Line 3092: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)

3088: END source_value
3089: , null source_meaning
3090: FROM xla_events_gt xet
3091: , PN_XLA_EXTRACT_HEADERS_V h1
3092: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
3093: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
3094: AND xet.event_type_code = C_EVENT_TYPE_CODE
3095: AND h1.event_id = xet.event_id
3096:

Line 3224: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)

3220: END source_value
3221: , null source_meaning
3222: FROM xla_events_gt xet
3223: , PN_XLA_EXTRACT_LINES_V l2
3224: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
3225: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
3226: AND xet.event_type_code = C_EVENT_TYPE_CODE
3227: AND l2.event_id = xet.event_id
3228: AND l2.ledger_id (+) = p_sla_ledger_id

Line 4342: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)

4338: END source_value
4339: , null source_meaning
4340: FROM xla_events_gt xet
4341: , PN_XLA_EXTRACT_HEADERS_V h1
4342: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
4343: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
4344: AND xet.event_type_code = C_EVENT_TYPE_CODE
4345: AND h1.event_id = xet.event_id
4346:

Line 4474: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)

4470: END source_value
4471: , null source_meaning
4472: FROM xla_events_gt xet
4473: , PN_XLA_EXTRACT_LINES_V l2
4474: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
4475: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
4476: AND xet.event_type_code = C_EVENT_TYPE_CODE
4477: AND l2.event_id = xet.event_id
4478: AND l2.ledger_id (+) = p_sla_ledger_id