APPS.PAY_FR_BAL_UPLOAD dependencies on PAY_BALANCE_BATCH_LINES

Line 158: batch_line_id pay_balance_batch_lines.batch_line_id%TYPE,

154: -----------------------------------------------------------------------------
155: procedure validate_batch_lines(p_batch_id number)
156: is
157: type t_message_line is record (
158: batch_line_id pay_balance_batch_lines.batch_line_id%TYPE,
159: message_number binary_integer);
160: type t_message_lines is table of t_message_line index by binary_integer;
161: type t_messages is table of pay_message_lines.line_text%TYPE
162: index by binary_integer;

Line 173: from pay_balance_batch_lines BL

169: --where batch_id = p_batch_id;
170: --
171: cursor csr_batch_line_validate(p_batch_id number) is
172: select *
173: from pay_balance_batch_lines BL
174: where BL.batch_id = p_batch_id
175: and BL.batch_line_status in ('V','E')
176: for update;
177: --

Line 216: update pay_balance_batch_lines

212: end write_message_lines;
213: --
214: procedure error_message_line(p_batch_line_id number) is
215: begin
216: update pay_balance_batch_lines
217: set batch_line_status = 'E'
218: where batch_id = p_batch_id
219: and batch_line_id = p_batch_line_id;
220: end error_message_line;

Line 310: from pay_balance_batch_lines bbl,

306: pbt2.balance_uom uom,
307: nvl(pbt2.currency_code,l_BG_currency_code) currency_code
308: from pay_balance_types pbt2
309: where pbt2.balance_type_id in (select pbt.balance_type_id
310: from pay_balance_batch_lines bbl,
311: pay_balance_types pbt
312: where bbl.batch_id = p_batch_id
313: and (bbl.balance_type_id = pbt.balance_type_id or
314: (bbl.balance_type_id is null