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.JTY_TAE_GEN_PVT dependencies on JTY_TRANS_USG_PGM_DETAILS

Line 1437: from jty_trans_usg_pgm_details a

1433: a.program_name
1434: ,decode(cl_mode, 'DATE EFFECTIVE', a.batch_dea_trans_table_name,'DEA INCREMENTAL', a.batch_dea_trans_table_name, a.batch_trans_table_name)
1435: ,a.batch_nm_trans_table_name
1436: ,a.batch_match_table_name
1437: from jty_trans_usg_pgm_details a
1438: where a.source_id = cl_source_id
1439: and a.trans_type_id = cl_trans_id
1440: and a.batch_enable_flag = 'Y';
1441:

Line 1442: TYPE l_pgm_name_tbl_type IS TABLE OF jty_trans_usg_pgm_details.program_name%TYPE;

1438: where a.source_id = cl_source_id
1439: and a.trans_type_id = cl_trans_id
1440: and a.batch_enable_flag = 'Y';
1441:
1442: TYPE l_pgm_name_tbl_type IS TABLE OF jty_trans_usg_pgm_details.program_name%TYPE;
1443: TYPE l_trans_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_trans_table_name%TYPE;
1444: TYPE l_nm_trans_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_nm_trans_table_name%TYPE;
1445: TYPE l_match_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_match_table_name%TYPE;
1446:

Line 1443: TYPE l_trans_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_trans_table_name%TYPE;

1439: and a.trans_type_id = cl_trans_id
1440: and a.batch_enable_flag = 'Y';
1441:
1442: TYPE l_pgm_name_tbl_type IS TABLE OF jty_trans_usg_pgm_details.program_name%TYPE;
1443: TYPE l_trans_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_trans_table_name%TYPE;
1444: TYPE l_nm_trans_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_nm_trans_table_name%TYPE;
1445: TYPE l_match_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_match_table_name%TYPE;
1446:
1447: l_pgm_name_tbl l_pgm_name_tbl_type;

Line 1444: TYPE l_nm_trans_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_nm_trans_table_name%TYPE;

1440: and a.batch_enable_flag = 'Y';
1441:
1442: TYPE l_pgm_name_tbl_type IS TABLE OF jty_trans_usg_pgm_details.program_name%TYPE;
1443: TYPE l_trans_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_trans_table_name%TYPE;
1444: TYPE l_nm_trans_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_nm_trans_table_name%TYPE;
1445: TYPE l_match_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_match_table_name%TYPE;
1446:
1447: l_pgm_name_tbl l_pgm_name_tbl_type;
1448: l_trans_tbl l_trans_tbl_type;

Line 1445: TYPE l_match_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_match_table_name%TYPE;

1441:
1442: TYPE l_pgm_name_tbl_type IS TABLE OF jty_trans_usg_pgm_details.program_name%TYPE;
1443: TYPE l_trans_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_trans_table_name%TYPE;
1444: TYPE l_nm_trans_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_nm_trans_table_name%TYPE;
1445: TYPE l_match_tbl_type IS TABLE OF jty_trans_usg_pgm_details.batch_match_table_name%TYPE;
1446:
1447: l_pgm_name_tbl l_pgm_name_tbl_type;
1448: l_trans_tbl l_trans_tbl_type;
1449: l_nm_trans_tbl l_nm_trans_tbl_type;