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_MAG_UTILS dependencies on PAY_MAGNETIC_BLOCKS

Line 877: FROM pay_magnetic_blocks pmb,

873: pmb.main_block_flag main_block_flag,
874: pmb2.block_name next_block_name,
875: pmr.next_block_id next_block_id,
876: ff.formula_name formula_name
877: FROM pay_magnetic_blocks pmb,
878: pay_magnetic_records pmr,
879: pay_magnetic_blocks pmb2,
880: ff_formulas_f ff
881: WHERE pmb.magnetic_block_id = p_magnetic_block_id

Line 879: pay_magnetic_blocks pmb2,

875: pmr.next_block_id next_block_id,
876: ff.formula_name formula_name
877: FROM pay_magnetic_blocks pmb,
878: pay_magnetic_records pmr,
879: pay_magnetic_blocks pmb2,
880: ff_formulas_f ff
881: WHERE pmb.magnetic_block_id = p_magnetic_block_id
882: AND pmb.magnetic_block_id = pmr.magnetic_block_id
883: AND pmr.next_block_id = pmb2.magnetic_block_id (+)

Line 927: -- Cursor to check for an existance of the report format in pay_magnetic_blocks

923: FUNCTION Org_Info_Exists ( p_org_info_type IN VARCHAR2) RETURN BOOLEAN IS
924: --
925: l_dummy varchar2(1);
926: --
927: -- Cursor to check for an existance of the report format in pay_magnetic_blocks
928: -- table.
929: --
930: CURSOR c_org_exists IS
931: SELECT null

Line 968: -- Cursor to check for an existance of the report format in pay_magnetic_blocks

964: PROCEDURE Report_Exists (p_report_format in varchar2) is
965: --
966: l_dummy varchar2(1);
967: --
968: -- Cursor to check for an existance of the report format in pay_magnetic_blocks
969: -- table.
970: --
971: CURSOR c_report_exists IS
972: SELECT null

Line 973: FROM pay_magnetic_blocks pmb

969: -- table.
970: --
971: CURSOR c_report_exists IS
972: SELECT null
973: FROM pay_magnetic_blocks pmb
974: WHERE pmb.report_format = p_report_format;
975: --
976: BEGIN
977: --

Line 1023: FROM pay_magnetic_blocks pmb

1019: -- the report format to be produced.
1020: --
1021: CURSOR c_magnetic_block_id IS
1022: SELECT pmb.magnetic_block_id
1023: FROM pay_magnetic_blocks pmb
1024: WHERE pmb.report_format = p_report_format
1025: AND pmb.main_block_flag = 'Y';
1026: --
1027: BEGIN