APPS.AR_AGING_BUCKETS_PKG dependencies on AR_AGING_MFAR_EXTRACT

Line 94: TYPE aging_mfar_tab IS TABLE OF ar_aging_mfar_extract%ROWTYPE INDEX BY BINARY_INTEGER;

90: pg_temp_contact_name HZ_PARTIES.PARTY_NAME%TYPE;
91:
92: p_not_implemented_exp EXCEPTION;
93:
94: TYPE aging_mfar_tab IS TABLE OF ar_aging_mfar_extract%ROWTYPE INDEX BY BINARY_INTEGER;
95:
96: TYPE req_status_type IS RECORD (
97: request_id NUMBER(15),
98: dev_phase VARCHAR2(255),

Line 627: from ar_aging_mfar_extract mfar,

623: from ar_aging_extract ext,
624: ( select mfar.*,
625: '||pg_accounting_flexfield||' sort_field1,
626: '||pg_acct_flex_bal_seg||' bal_segment_value
627: from ar_aging_mfar_extract mfar,
628: gl_code_combinations c
629: where c.code_combination_id = mfar.code_combination_id
630: ) mfar
631: where ext.parent_request_id = mfar.parent_request_id(+)

Line 688: from ar_aging_mfar_extract mfar,

684: from ar_aging_extract ext,
685: ( select mfar.*,
686: '||pg_accounting_flexfield||' sort_field1,
687: '||pg_acct_flex_bal_seg||' bal_segment_value
688: from ar_aging_mfar_extract mfar,
689: gl_code_combinations c
690: where c.code_combination_id = mfar.code_combination_id ) mfar
691: where ext.parent_request_id = mfar.parent_request_id(+)
692: and ext.payment_schedule_id = mfar.payment_schedule_id(+)

Line 1287: FROM ar_aging_mfar_extract

1283: FROM ar_aging_extract
1284: WHERE parent_request_id = pg_request_id;
1285:
1286: DELETE
1287: FROM ar_aging_mfar_extract
1288: WHERE parent_request_id = pg_request_id;
1289:
1290: IF PG_DEBUG in ('Y', 'C') THEN
1291: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.cleanup_staging_tables()-');

Line 2908: INSERT INTO ar_aging_mfar_extract

2904:
2905: END LOOP;
2906:
2907: FORALL i IN l_aging_mfar_tab.FIRST..l_aging_mfar_tab.LAST
2908: INSERT INTO ar_aging_mfar_extract
2909: VALUES l_aging_mfar_tab(i);
2910:
2911: EXIT WHEN aging_ps_cur%NOTFOUND;
2912: END LOOP;