APPS.ARP_ACCT_EVENT_PKG dependencies on AR_DISTRIBUTIONS

Line 667: FROM ar_distributions_all ard,

663: p_end_date IN DATE,
664: p_org_id IN NUMBER)
665: IS
666: SELECT adj.adjustment_id
667: FROM ar_distributions_all ard,
668: ar_adjustments_all adj
669: WHERE ard.source_table = 'ADJ'
670: AND ard.source_id = adj.adjustment_id
671: AND adj.gl_date BETWEEN p_start_date AND p_end_date

Line 681: AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

677: FROM xla_distribution_links lk,
678: xla_ae_lines ae
679: WHERE ard.line_id = lk.source_distribution_id_num_1
680: AND lk.application_id = 222
681: AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
682: AND ae.application_id = 222
683: AND lk.ae_header_id = ae.ae_header_id
684: AND lk.ae_line_num = ae.ae_line_num);
685: l_adj_id NUMBER;

Line 854: FROM ar_distributions_all ard,

850: p_org_id IN NUMBER,
851: p_type IN VARCHAR2)
852: IS
853: SELECT crh.cash_receipt_id
854: FROM ar_distributions_all ard,
855: ar_cash_receipt_history_all crh,
856: ar_cash_receipts_all cr
857: WHERE ard.source_table = 'CRH'
858: AND ard.source_id = crh.cash_receipt_history_id

Line 872: AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

868: FROM xla_distribution_links lk,
869: xla_ae_lines ae
870: WHERE ard.line_id = lk.source_distribution_id_num_1
871: AND lk.application_id = 222
872: AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
873: AND ae.application_id = 222
874: AND lk.ae_header_id = ae.ae_header_id
875: AND lk.ae_line_num = ae.ae_line_num);
876: l_cr_id NUMBER;

Line 950: FROM ar_distributions_all ard,

946: p_org_id IN NUMBER,
947: p_type IN VARCHAR2)
948: IS
949: SELECT ra.receivable_application_id
950: FROM ar_distributions_all ard,
951: ar_receivable_applications_all ra
952: WHERE ard.source_table = 'RA'
953: AND ra.status = 'APP'
954: AND ard.source_id = ra.receivable_application_id

Line 968: AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

964: FROM xla_distribution_links lk,
965: xla_ae_lines ae
966: WHERE ard.line_id = lk.source_distribution_id_num_1
967: AND lk.application_id = 222
968: AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
969: AND ae.application_id = 222
970: AND lk.ae_header_id = ae.ae_header_id
971: AND lk.ae_line_num = ae.ae_line_num);
972: l_ra_id NUMBER;

Line 1042: FROM ar_distributions_all ard,

1038: p_end_date IN DATE,
1039: p_org_id IN NUMBER)
1040: IS
1041: SELECT th.customer_trx_id
1042: FROM ar_distributions_all ard,
1043: ar_transaction_history_all th
1044: WHERE ard.source_table = 'TH'
1045: AND ard.source_id = th.transaction_history_id
1046: AND th.gl_date BETWEEN p_start_date AND p_end_date

Line 1055: AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

1051: FROM xla_distribution_links lk,
1052: xla_ae_lines ae
1053: WHERE ard.line_id = lk.source_distribution_id_num_1
1054: AND lk.application_id = 222
1055: AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
1056: AND ae.application_id = 222
1057: AND lk.ae_header_id = ae.ae_header_id
1058: AND lk.ae_line_num = ae.ae_line_num);
1059: l_trx_id NUMBER;

Line 1484: UPDATE ar_distributions

1480: ,p_transfer_to_gl_flag => p_transfer_to_gl_flag
1481: ,p_post_in_gl_flag => p_post_in_gl_flag);
1482:
1483: IF x_retcode = 'S' AND p_entity_code = 'RECEIPTS' THEN
1484: UPDATE ar_distributions
1485: SET third_party_id = p_new_third_party_id
1486: ,third_party_sub_id = p_new_site_id
1487: WHERE
1488: ( SOURCE_TABLE, SOURCE_ID ) IN