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 504: FROM pay_temp_balance_adjustments

500: ,tax_unit_id
501: ,jurisdiction_code
502: ,source_text
503: ,source_text2
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;

Line 509: l_adj_orig_entry_id pay_temp_balance_adjustments.original_entry_id%TYPE;

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

Line 511: l_adj_source_id pay_temp_balance_adjustments.source_id%TYPE;

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

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

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

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

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