eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_BAL_UPLOAD dependencies on PAY_TEMP_BALANCE_ADJUSTMENTS

Line 508: FROM pay_temp_balance_adjustments

504: ,tax_unit_id
505: ,jurisdiction_code
506: ,source_text
507: ,source_text2
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;

Line 513: l_adj_orig_entry_id pay_temp_balance_adjustments.original_entry_id%TYPE;

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;
517: l_adj_tax_unit_id pay_temp_balance_adjustments.tax_unit_id%TYPE;

Line 515: l_adj_source_id pay_temp_balance_adjustments.source_id%TYPE;

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;
519: l_adj_source_text pay_temp_balance_adjustments.source_text%TYPE;

Line 517: l_adj_tax_unit_id pay_temp_balance_adjustments.tax_unit_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;
521: l_adj_source_text2 pay_temp_balance_adjustments.source_text2%TYPE;

Line 519: l_adj_source_text pay_temp_balance_adjustments.source_text%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;
523: l_adj_jur_code pay_temp_balance_adjustments.jurisdiction_code%TYPE;

Line 521: l_adj_source_text2 pay_temp_balance_adjustments.source_text2%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);
525: l_message VARCHAR2(250);

Line 523: l_adj_jur_code pay_temp_balance_adjustments.jurisdiction_code%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:
527: BEGIN