APPS.JL_BR_AR_GENERATE_DEBIT_MEMO dependencies on RA_SALESREPS

Line 77: RA_CUST_TRX_TYPES e RA_SALESREPS AR_MEMO_LINES*/

73: FROM ra_account_default_segments
74: WHERE gl_default_id = X_gl_default_id;
75:
76: /* Get the account id to the Revene and Receivables tables
77: RA_CUST_TRX_TYPES e RA_SALESREPS AR_MEMO_LINES*/
78:
79: BEGIN
80: SELECT gl_id_rev, gl_id_rec
81: INTO X_cust_rev_id, X_cust_rec_id

Line 92: FROM ra_salesreps

88:
89: BEGIN
90: SELECT gl_id_rev, gl_id_rec
91: INTO X_sale_rev_id, X_sale_rec_id
92: FROM ra_salesreps
93: WHERE salesrep_id = X_salesrep_id;
94:
95: EXCEPTION
96: WHEN NO_DATA_FOUND THEN NULL;

Line 115: senao verifica se segmento esta tab. RA_SALESREPS entao

111: se o tipo de conta for Revenue Account entao
112: busca o id da conta Rev. da RA_CUST_TRX_TYPES
113: senao se o tipo de conta for Receivable Account entao
114: busca o id da conta Rec. da RA_CUST_TRX_TYPES
115: senao verifica se segmento esta tab. RA_SALESREPS entao
116: se o tipo de conta for Revenue Account entao
117: busca o id da conta Rev. da RA_SALESREPS
118: senao se o tipo de conta for Receivable Account entao
119: busca o id da conta Rec. da RA_SALESREPS

Line 117: busca o id da conta Rev. da RA_SALESREPS

113: senao se o tipo de conta for Receivable Account entao
114: busca o id da conta Rec. da RA_CUST_TRX_TYPES
115: senao verifica se segmento esta tab. RA_SALESREPS entao
116: se o tipo de conta for Revenue Account entao
117: busca o id da conta Rev. da RA_SALESREPS
118: senao se o tipo de conta for Receivable Account entao
119: busca o id da conta Rec. da RA_SALESREPS
120: */
121: IF X_constant IS NULL THEN

Line 119: busca o id da conta Rec. da RA_SALESREPS

115: senao verifica se segmento esta tab. RA_SALESREPS entao
116: se o tipo de conta for Revenue Account entao
117: busca o id da conta Rev. da RA_SALESREPS
118: senao se o tipo de conta for Receivable Account entao
119: busca o id da conta Rec. da RA_SALESREPS
120: */
121: IF X_constant IS NULL THEN
122: IF X_table_name = 'RA_CUST_TRX_TYPES' THEN
123: IF X_account_type = 'REV' THEN

Line 128: ELSIF X_table_name = 'RA_SALESREPS' THEN

124: X_gl_id := X_cust_rev_id;
125: ELSIF X_account_type = 'REC' THEN
126: X_gl_id := X_cust_rec_id;
127: END IF;
128: ELSIF X_table_name = 'RA_SALESREPS' THEN
129: IF X_account_type = 'REV' THEN
130: X_gl_id := X_sale_rev_id;
131: ELSIF X_account_type = 'REC' THEN
132: X_gl_id := X_sale_rec_id;