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.PV_PARTNER_PROGRAM_PVT dependencies on AMS_USER_STATUSES_B

Line 966: FROM ams_user_statuses_b

962:
963: cursor c_status_code(p_prgm_user_status_id number) is
964:
965: SELECT system_status_code
966: FROM ams_user_statuses_b
967: WHERE user_status_id = p_prgm_user_status_id
968: AND system_status_type = 'PV_PROGRAM_STATUS'
969: AND enabled_flag = 'Y';
970:

Line 1734: FROM AMS_USER_STATUSES_B

1730: CONNECT BY PRIOR program_id = program_parent_id;
1731:
1732: CURSOR c_get_status_code(cv_status_code VARCHAR2) IS
1733: SELECT user_status_id
1734: FROM AMS_USER_STATUSES_B
1735: where SYSTEM_STATUS_TYPE='PV_PROGRAM_STATUS'
1736: and SYSTEM_STATUS_CODE=cv_status_code;
1737:
1738: l_api_name CONSTANT VARCHAR2(30) := 'Update_Partner_Program';

Line 3838: FROM ams_user_statuses_b

3834: AND program_status_code NOT IN ('CLOSED', 'ARCHIVE');
3835:
3836: CURSOR c_get_user_status IS
3837: SELECT user_status_id
3838: FROM ams_user_statuses_b
3839: WHERE system_status_type like 'PV_PROGRAM_STATUS'
3840: AND system_status_code = 'CLOSED'
3841: AND enabled_flag = 'Y';
3842: