DBA Data[Home] [Help]

APPS.ARP_BR_REMIT_FUNCTION dependencies on AR_DISTRIBUTIONS

Line 13: CURSOR dist_amount(p2_status IN ar_distributions.source_type%TYPE) is

9:
10: l_field varchar2(30);
11: l_amount NUMBER;
12:
13: CURSOR dist_amount(p2_status IN ar_distributions.source_type%TYPE) is
14: select amount_dr
15: from ar_distributions
16: where source_id=p_trh_id
17: and source_table='TH'

Line 15: from ar_distributions

11: l_amount NUMBER;
12:
13: CURSOR dist_amount(p2_status IN ar_distributions.source_type%TYPE) is
14: select amount_dr
15: from ar_distributions
16: where source_id=p_trh_id
17: and source_table='TH'
18: and source_type=p2_status;
19:

Line 78: CURSOR dist_amount(p2_status IN ar_distributions.source_type%TYPE) is

74:
75: l_field varchar2(30);
76: l_amount NUMBER;
77:
78: CURSOR dist_amount(p2_status IN ar_distributions.source_type%TYPE) is
79: select acctd_amount_dr
80: from ar_distributions
81: where source_id=p_trh_id
82: and source_table='TH'

Line 80: from ar_distributions

76: l_amount NUMBER;
77:
78: CURSOR dist_amount(p2_status IN ar_distributions.source_type%TYPE) is
79: select acctd_amount_dr
80: from ar_distributions
81: where source_id=p_trh_id
82: and source_table='TH'
83: and source_type=p2_status;
84: