APPS.AMW_CONTROL_PVT dependencies on AMW_CONTROLS_TL

Line 63: FROM amw_controls_tl;

59: l_draft_status_counter NUMBER := 0;
60: l_description varchar2(4000);
61: CURSOR get_name IS
62: SELECT DISTINCT NAME
63: FROM amw_controls_tl;
64: l_get_name get_name%ROWTYPE;
65: l_control_id NUMBER;
66: l_controlname VARCHAR2 (240);
67: CURSOR update_enabled IS

Line 94: amw_controls_tl act,

90: DECODE(ac.approval_status,'D', DECODE (ac.end_date,NULL, 'DeleteEnabled','DeleteDisabled'),'DeleteDisabled') delete_switcher,
91: ac.latest_revision_flag|| ac.curr_approved_flag control_revision_choice,
92: amw_controls_page_pkg.get_lookup_value('AMW_REVISION_VIEW_CHOICE',ac.latest_revision_flag|| ac.curr_approved_flag) revision
93: FROM amw_controls_b ac,
94: amw_controls_tl act,
95: fnd_application_vl fav,
96: per_jobs pj
97: WHERE ac.application_id = fav.application_id(+)
98: AND ac.job_id = pj.job_id(+)

Line 110: FROM amw_controls_b ac, amw_controls_tl act

106: CURSOR rev_enabled IS
107: SELECT act.NAME, act.description, ac.control_rev_id, ac.control_id, ac.rev_num,
108: ac.object_version_number, ac.approval_status,
109: ac.curr_approved_flag, ac.latest_revision_flag, ac.requestor_id
110: FROM amw_controls_b ac, amw_controls_tl act
111: WHERE ac.latest_revision_flag = 'Y'
112: AND act.control_rev_id = ac.control_rev_id
113: AND act.LANGUAGE = USERENV ('LANG')
114: AND ( ac.approval_status = 'A'

Line 1313: FROM amw_controls_tl

1309: CURSOR c_desc IS
1310: SELECT description,
1311: verification_source_name,
1312: verification_instruction
1313: FROM amw_controls_tl
1314: WHERE control_rev_id = p_control_rec.control_rev_id;
1315: l_desc c_desc%ROWTYPE;
1316: BEGIN
1317: x_complete_rec := p_control_rec;