APPS.PAY_IN_BAL_UPLOAD dependencies on PAY_BALANCE_BATCH_LINES

Line 492: from pay_balance_batch_lines pbbl

488: ,pbbl.tax_unit_id
489: ,pbbl.jurisdiction_code
490: ,pbbl.source_text
491: ,pbbl.source_text2
492: from pay_balance_batch_lines pbbl
493: where pbbl.batch_line_id = p_batch_line_id;
494:
495:
496: -- Get jurisdiction code and original_entry_id for previously tested adjustments

Line 508: l_orig_entry_id pay_balance_batch_lines.original_entry_id%TYPE;

504: FROM pay_temp_balance_adjustments
505: WHERE batch_line_id = p_test_batch_line_id;
506:
507: -- The balance returned by the include check.
508: l_orig_entry_id pay_balance_batch_lines.original_entry_id%TYPE;
509: l_adj_orig_entry_id pay_temp_balance_adjustments.original_entry_id%TYPE;
510: l_source_id pay_balance_batch_lines.source_id%TYPE;
511: l_adj_source_id pay_temp_balance_adjustments.source_id%TYPE;
512: l_tax_unit_id pay_balance_batch_lines.tax_unit_id%TYPE;

Line 510: l_source_id pay_balance_batch_lines.source_id%TYPE;

506:
507: -- The balance returned by the include check.
508: l_orig_entry_id pay_balance_batch_lines.original_entry_id%TYPE;
509: l_adj_orig_entry_id pay_temp_balance_adjustments.original_entry_id%TYPE;
510: l_source_id pay_balance_batch_lines.source_id%TYPE;
511: l_adj_source_id pay_temp_balance_adjustments.source_id%TYPE;
512: l_tax_unit_id pay_balance_batch_lines.tax_unit_id%TYPE;
513: l_adj_tax_unit_id pay_temp_balance_adjustments.tax_unit_id%TYPE;
514: l_source_text pay_balance_batch_lines.source_text%TYPE;

Line 512: l_tax_unit_id pay_balance_batch_lines.tax_unit_id%TYPE;

508: l_orig_entry_id pay_balance_batch_lines.original_entry_id%TYPE;
509: l_adj_orig_entry_id pay_temp_balance_adjustments.original_entry_id%TYPE;
510: l_source_id pay_balance_batch_lines.source_id%TYPE;
511: l_adj_source_id pay_temp_balance_adjustments.source_id%TYPE;
512: l_tax_unit_id pay_balance_batch_lines.tax_unit_id%TYPE;
513: l_adj_tax_unit_id pay_temp_balance_adjustments.tax_unit_id%TYPE;
514: l_source_text pay_balance_batch_lines.source_text%TYPE;
515: l_adj_source_text pay_temp_balance_adjustments.source_text%TYPE;
516: l_source_text2 pay_balance_batch_lines.source_text2%TYPE;

Line 514: l_source_text pay_balance_batch_lines.source_text%TYPE;

510: l_source_id pay_balance_batch_lines.source_id%TYPE;
511: l_adj_source_id pay_temp_balance_adjustments.source_id%TYPE;
512: l_tax_unit_id pay_balance_batch_lines.tax_unit_id%TYPE;
513: l_adj_tax_unit_id pay_temp_balance_adjustments.tax_unit_id%TYPE;
514: l_source_text pay_balance_batch_lines.source_text%TYPE;
515: l_adj_source_text pay_temp_balance_adjustments.source_text%TYPE;
516: l_source_text2 pay_balance_batch_lines.source_text2%TYPE;
517: l_adj_source_text2 pay_temp_balance_adjustments.source_text2%TYPE;
518: l_jur_code pay_balance_batch_lines.jurisdiction_code%TYPE;

Line 516: l_source_text2 pay_balance_batch_lines.source_text2%TYPE;

512: l_tax_unit_id pay_balance_batch_lines.tax_unit_id%TYPE;
513: l_adj_tax_unit_id pay_temp_balance_adjustments.tax_unit_id%TYPE;
514: l_source_text pay_balance_batch_lines.source_text%TYPE;
515: l_adj_source_text pay_temp_balance_adjustments.source_text%TYPE;
516: l_source_text2 pay_balance_batch_lines.source_text2%TYPE;
517: l_adj_source_text2 pay_temp_balance_adjustments.source_text2%TYPE;
518: l_jur_code pay_balance_batch_lines.jurisdiction_code%TYPE;
519: l_adj_jur_code pay_temp_balance_adjustments.jurisdiction_code%TYPE;
520: l_procedure VARCHAR2(250);

Line 518: l_jur_code pay_balance_batch_lines.jurisdiction_code%TYPE;

514: l_source_text pay_balance_batch_lines.source_text%TYPE;
515: l_adj_source_text pay_temp_balance_adjustments.source_text%TYPE;
516: l_source_text2 pay_balance_batch_lines.source_text2%TYPE;
517: l_adj_source_text2 pay_temp_balance_adjustments.source_text2%TYPE;
518: l_jur_code pay_balance_batch_lines.jurisdiction_code%TYPE;
519: l_adj_jur_code pay_temp_balance_adjustments.jurisdiction_code%TYPE;
520: l_procedure VARCHAR2(250);
521: l_message VARCHAR2(250);
522: