APPS.PA_ASSIGNMENT_APPROVAL_PVT dependencies on PA_WF_PROCESSES

Line 1101: FROM pa_wf_processes

1097: IS
1098:
1099: CURSOR get_item_key IS
1100: SELECT item_key, item_type
1101: FROM pa_wf_processes
1102: WHERE item_key = (
1103: SELECT max(item_key)
1104: FROM pa_wf_processes
1105: WHERE wf_type_code = 'ASSIGNMENT_APPROVAL'

Line 1104: FROM pa_wf_processes

1100: SELECT item_key, item_type
1101: FROM pa_wf_processes
1102: WHERE item_key = (
1103: SELECT max(item_key)
1104: FROM pa_wf_processes
1105: WHERE wf_type_code = 'ASSIGNMENT_APPROVAL'
1106: AND entity_key1 = to_char(p_project_id)
1107: AND entity_key2 = to_char(p_assignment_id)
1108: )

Line 1111: l_item_key pa_wf_processes.item_key%TYPE;

1107: AND entity_key2 = to_char(p_assignment_id)
1108: )
1109: and item_type = 'PAWFAAP';
1110:
1111: l_item_key pa_wf_processes.item_key%TYPE;
1112: l_item_type pa_wf_processes.item_type%TYPE;
1113:
1114: BEGIN
1115:

Line 1112: l_item_type pa_wf_processes.item_type%TYPE;

1108: )
1109: and item_type = 'PAWFAAP';
1110:
1111: l_item_key pa_wf_processes.item_key%TYPE;
1112: l_item_type pa_wf_processes.item_type%TYPE;
1113:
1114: BEGIN
1115:
1116: -- Initialize the Error Stack