APPS.ZX_TAX_STR_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 64: l_trx_number ra_customer_trx_all.trx_number%TYPE := null;

60: *======================================================================*/
61: FUNCTION get_credit_memo_trx_number(p_previous_customer_trx_id IN NUMBER)
62: RETURN VARCHAR IS
63:
64: l_trx_number ra_customer_trx_all.trx_number%TYPE := null;
65:
66: BEGIN
67: IF p_previous_customer_trx_id IS NOT NULL THEN
68: BEGIN

Line 71: from ra_customer_trx_all

67: IF p_previous_customer_trx_id IS NOT NULL THEN
68: BEGIN
69: Select trx_number
70: into l_trx_number
71: from ra_customer_trx_all
72: where customer_trx_id = p_previous_customer_trx_id;
73: EXCEPTION
74: WHEN NO_DATA_FOUND THEN
75: NULL;

Line 99: l_trx_date ra_customer_trx_all.trx_date%TYPE := null;

95: | refering.
96: *==========================================================================*/
97: FUNCTION get_credit_memo_trx_date(p_previous_customer_trx_id IN NUMBER ) RETURN DATE IS
98:
99: l_trx_date ra_customer_trx_all.trx_date%TYPE := null;
100:
101: BEGIN
102: IF p_previous_customer_trx_id IS NOT NULL THEN
103: BEGIN

Line 106: from ra_customer_trx_all

102: IF p_previous_customer_trx_id IS NOT NULL THEN
103: BEGIN
104: Select trx_date
105: into l_trx_date
106: from ra_customer_trx_all
107: where customer_trx_id = p_previous_customer_trx_id;
108: EXCEPTION
109: WHEN NO_DATA_FOUND THEN
110: NULL;