APPS.PAY_IN_BAL_UPLOAD dependencies on PAY_BALANCE_BATCH_LINES

Line 496: from pay_balance_batch_lines pbbl

492: ,pbbl.tax_unit_id
493: ,pbbl.jurisdiction_code
494: ,pbbl.source_text
495: ,pbbl.source_text2
496: from pay_balance_batch_lines pbbl
497: where pbbl.batch_line_id = p_batch_line_id;
498:
499:
500: -- Get jurisdiction code and original_entry_id for previously tested adjustments

Line 512: l_orig_entry_id pay_balance_batch_lines.original_entry_id%TYPE;

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

Line 514: l_source_id pay_balance_batch_lines.source_id%TYPE;

510:
511: -- The balance returned by the include check.
512: l_orig_entry_id pay_balance_batch_lines.original_entry_id%TYPE;
513: l_adj_orig_entry_id pay_temp_balance_adjustments.original_entry_id%TYPE;
514: l_source_id pay_balance_batch_lines.source_id%TYPE;
515: l_adj_source_id pay_temp_balance_adjustments.source_id%TYPE;
516: l_tax_unit_id pay_balance_batch_lines.tax_unit_id%TYPE;
517: l_adj_tax_unit_id pay_temp_balance_adjustments.tax_unit_id%TYPE;
518: l_source_text pay_balance_batch_lines.source_text%TYPE;

Line 516: l_tax_unit_id pay_balance_batch_lines.tax_unit_id%TYPE;

512: l_orig_entry_id pay_balance_batch_lines.original_entry_id%TYPE;
513: l_adj_orig_entry_id pay_temp_balance_adjustments.original_entry_id%TYPE;
514: l_source_id pay_balance_batch_lines.source_id%TYPE;
515: l_adj_source_id pay_temp_balance_adjustments.source_id%TYPE;
516: l_tax_unit_id pay_balance_batch_lines.tax_unit_id%TYPE;
517: l_adj_tax_unit_id pay_temp_balance_adjustments.tax_unit_id%TYPE;
518: l_source_text pay_balance_batch_lines.source_text%TYPE;
519: l_adj_source_text pay_temp_balance_adjustments.source_text%TYPE;
520: l_source_text2 pay_balance_batch_lines.source_text2%TYPE;

Line 518: l_source_text pay_balance_batch_lines.source_text%TYPE;

514: l_source_id pay_balance_batch_lines.source_id%TYPE;
515: l_adj_source_id pay_temp_balance_adjustments.source_id%TYPE;
516: l_tax_unit_id pay_balance_batch_lines.tax_unit_id%TYPE;
517: l_adj_tax_unit_id pay_temp_balance_adjustments.tax_unit_id%TYPE;
518: l_source_text pay_balance_batch_lines.source_text%TYPE;
519: l_adj_source_text pay_temp_balance_adjustments.source_text%TYPE;
520: l_source_text2 pay_balance_batch_lines.source_text2%TYPE;
521: l_adj_source_text2 pay_temp_balance_adjustments.source_text2%TYPE;
522: l_jur_code pay_balance_batch_lines.jurisdiction_code%TYPE;

Line 520: l_source_text2 pay_balance_batch_lines.source_text2%TYPE;

516: l_tax_unit_id pay_balance_batch_lines.tax_unit_id%TYPE;
517: l_adj_tax_unit_id pay_temp_balance_adjustments.tax_unit_id%TYPE;
518: l_source_text pay_balance_batch_lines.source_text%TYPE;
519: l_adj_source_text pay_temp_balance_adjustments.source_text%TYPE;
520: l_source_text2 pay_balance_batch_lines.source_text2%TYPE;
521: l_adj_source_text2 pay_temp_balance_adjustments.source_text2%TYPE;
522: l_jur_code pay_balance_batch_lines.jurisdiction_code%TYPE;
523: l_adj_jur_code pay_temp_balance_adjustments.jurisdiction_code%TYPE;
524: l_procedure VARCHAR2(250);

Line 522: l_jur_code pay_balance_batch_lines.jurisdiction_code%TYPE;

518: l_source_text pay_balance_batch_lines.source_text%TYPE;
519: l_adj_source_text pay_temp_balance_adjustments.source_text%TYPE;
520: l_source_text2 pay_balance_batch_lines.source_text2%TYPE;
521: l_adj_source_text2 pay_temp_balance_adjustments.source_text2%TYPE;
522: l_jur_code pay_balance_batch_lines.jurisdiction_code%TYPE;
523: l_adj_jur_code pay_temp_balance_adjustments.jurisdiction_code%TYPE;
524: l_procedure VARCHAR2(250);
525: l_message VARCHAR2(250);
526: