APPS.JL_BR_AR_GENERATE_DEBIT_MEMO dependencies on RA_SALESREPS

Line 80: RA_CUST_TRX_TYPES e RA_SALESREPS AR_MEMO_LINES*/

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

Line 95: FROM ra_salesreps

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

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

126: se o tipo de conta for Revenue Account entao
127: busca o id da conta Rev. da RA_CUST_TRX_TYPES
128: senao se o tipo de conta for Receivable Account entao
129: busca o id da conta Rec. da RA_CUST_TRX_TYPES
130: senao verifica se segmento esta tab. RA_SALESREPS entao
131: se o tipo de conta for Revenue Account entao
132: busca o id da conta Rev. da RA_SALESREPS
133: senao se o tipo de conta for Receivable Account entao
134: busca o id da conta Rec. da RA_SALESREPS

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

128: senao se o tipo de conta for Receivable Account entao
129: busca o id da conta Rec. da RA_CUST_TRX_TYPES
130: senao verifica se segmento esta tab. RA_SALESREPS entao
131: se o tipo de conta for Revenue Account entao
132: busca o id da conta Rev. da RA_SALESREPS
133: senao se o tipo de conta for Receivable Account entao
134: busca o id da conta Rec. da RA_SALESREPS
135: */
136: IF X_constant IS NULL THEN

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

130: senao verifica se segmento esta tab. RA_SALESREPS entao
131: se o tipo de conta for Revenue Account entao
132: busca o id da conta Rev. da RA_SALESREPS
133: senao se o tipo de conta for Receivable Account entao
134: busca o id da conta Rec. da RA_SALESREPS
135: */
136: IF X_constant IS NULL THEN
137: IF X_table_name = 'RA_CUST_TRX_TYPES' THEN
138: IF X_account_type = 'REV' THEN

Line 143: ELSIF X_table_name = 'RA_SALESREPS' THEN

139: X_gl_id := X_cust_rev_id;
140: ELSIF X_account_type = 'REC' THEN
141: X_gl_id := X_cust_rec_id;
142: END IF;
143: ELSIF X_table_name = 'RA_SALESREPS' THEN
144: IF X_account_type = 'REV' THEN
145: X_gl_id := X_sale_rev_id;
146: ELSIF X_account_type = 'REC' THEN
147: X_gl_id := X_sale_rec_id;