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.PA_ASGMT_WFSTD dependencies on PA_PROJECT_ASSIGNMENTS

Line 121: FROM pa_project_assignments_v ppa

117: ppa.tp_percent_applied_override,
118: ppa.work_type_name,
119: ppa.transfer_price_rate, -- Added for bug 3051110
120: ppa.transfer_pr_rate_curr
121: FROM pa_project_assignments_v ppa
122: WHERE assignment_id = p_assignment_id;
123:
124: CURSOR csr_get_override_basis_name (p_override_basis_code IN VARCHAR2) IS
125: SELECT plks.meaning

Line 1572: FROM pa_project_assignments

1568: FUNCTION Is_approval_pending (p_assignment_id IN NUMBER) RETURN VARCHAR2
1569: IS
1570: CURSOR l_asgmt_csr IS
1571: SELECT NVL(pending_approval_flag,'N')
1572: FROM pa_project_assignments
1573: WHERE assignment_id = p_assignment_id;
1574: l_pending_approval_flag pa_project_assignments.pending_approval_flag%TYPE;
1575: BEGIN
1576: OPEN l_asgmt_csr;

Line 1574: l_pending_approval_flag pa_project_assignments.pending_approval_flag%TYPE;

1570: CURSOR l_asgmt_csr IS
1571: SELECT NVL(pending_approval_flag,'N')
1572: FROM pa_project_assignments
1573: WHERE assignment_id = p_assignment_id;
1574: l_pending_approval_flag pa_project_assignments.pending_approval_flag%TYPE;
1575: BEGIN
1576: OPEN l_asgmt_csr;
1577: FETCH l_asgmt_csr INTO l_pending_approval_flag;
1578: IF l_asgmt_csr%NOTFOUND THEN

Line 1613: l_asgmt_type pa_project_assignments.assignment_type%TYPE; /Added for bug 6408552/

1609: l_return_status VARCHAR2(1);
1610: l_msg_count NUMBER;
1611: l_msg_data VARCHAR2(2000);
1612:
1613: l_asgmt_type pa_project_assignments.assignment_type%TYPE; /*Added for bug 6408552*/
1614: BEGIN
1615:
1616: pa_debug.init_err_stack ('pa_asgmt_wfstd.Generate_URL');
1617: -- Return if WF Not Running

Line 1905: -- l_assignment_id pa_project_assignments.assignment_id%TYPE;

1901: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
1902:
1903: ---l_asgmt_success_status_code pa_project_statuses.project_status_code%TYPE;
1904: l_asgmt_success_status_code VARCHAR2(30);
1905: -- l_assignment_id pa_project_assignments.assignment_id%TYPE;
1906: l_assignment_id NUMBER;
1907: l_msg_count NUMBER;
1908: l_msg_data VARCHAR2(200);
1909: l_error_message_code VARCHAR2(200);

Line 1983: l_assignment_id pa_project_assignments.assignment_id%TYPE;

1979: , funcmode IN VARCHAR2
1980: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
1981:
1982: l_asgmt_failure_status_code pa_project_statuses.project_status_code%TYPE;
1983: l_assignment_id pa_project_assignments.assignment_id%TYPE;
1984: l_msg_count NUMBER;
1985: l_msg_data VARCHAR2(200);
1986: l_error_message_code VARCHAR2(200);
1987: l_return_status VARCHAR2(30);

Line 2149: l_assignment_id pa_project_assignments.assignment_id%TYPE;

2145: l_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2146: l_out_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2147: l_number_of_approvers NUMBER := 0;
2148: l_approvers_list_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2149: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2150: l_project_id pa_projects_all.project_id%TYPE;
2151: l_approver_user_name wf_users.name%type; ----- VARCHAR2(30); Commented for bug 3267790 VARCHAR2(100);
2152: /* Modified length from 30 to 100 for bug 3148857 */
2153: l_approver_person_id NUMBER := 0;

Line 2409: l_assignment_id pa_project_assignments.assignment_id%TYPE;

2405: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2406: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2407: l_number_of_recipients NUMBER := 0;
2408: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2409: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2410: l_project_id pa_projects_all.project_id%TYPE;
2411: l_approval_nf_rect_username VARCHAR2(100); /* Modified length from 30 to 100 for bug 3148857 */
2412: l_rect_person_id NUMBER := 0;
2413: l_recipient_type VARCHAR2(30);

Line 2650: l_assignment_id pa_project_assignments.assignment_id%TYPE;

2646: l_reject_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2647: l_out_reject_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2648: l_number_of_recipients NUMBER := 0;
2649: l_reject_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2650: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2651: l_project_id pa_projects_all.project_id%TYPE;
2652: l_reject_nf_rect_username wf_users.name%type; ---VARCHAR2(100); /* Modified length from 30 to 100 for bug 3148857 */ -- Changed for bug 3267790
2653: l_rect_person_id NUMBER := 0;
2654: l_recipient_type VARCHAR2(30);

Line 2892: l_assignment_id pa_project_assignments.assignment_id%TYPE;

2888: l_cancel_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2889: l_out_cancel_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2890: l_number_of_recipients NUMBER := 0;
2891: l_cancel_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2892: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2893: l_project_id pa_projects_all.project_id%TYPE;
2894: l_cancel_nf_rect_username wf_users.name%type; ----- VARCHAR2(30);Changed for bug 3267790
2895: --VARCHAR2(100); /* Modified length from 30 to 100 for bug 3148857 */
2896: l_rect_person_id NUMBER := 0;

Line 3188: l_assignment_type pa_project_assignments.assignment_type%TYPE;

3184: , actid IN NUMBER
3185: , funcmode IN VARCHAR2
3186: , resultout OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3187: IS
3188: l_assignment_type pa_project_assignments.assignment_type%TYPE;
3189: l_reapproval_flag VARCHAR2(1);
3190: BEGIN
3191: IF (funcmode <> wf_engine.eng_run) THEN
3192: resultout := wf_engine.eng_null;

Line 3387: l_assignment_id pa_project_assignments.assignment_id%TYPE;

3383: , actid IN NUMBER
3384: , funcmode IN VARCHAR2
3385: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
3386:
3387: l_assignment_id pa_project_assignments.assignment_id%TYPE;
3388: BEGIN
3389: l_assignment_id := wf_engine.GetItemAttrNumber
3390: (itemtype => itemtype,
3391: itemkey => itemkey,

Line 3430: UPDATE pa_project_assignments

3426: ELSE
3427: -- placeholder for any possible future values
3428: l_pending_approval_flag := 'N';
3429: END IF;
3430: UPDATE pa_project_assignments
3431: SET pending_approval_flag = l_pending_approval_flag,
3432: record_version_number = record_version_number + 1
3433: WHERE assignment_id = p_assignment_id;
3434: EXCEPTION

Line 3441: (p_assignment_id IN pa_project_assignments.assignment_id%TYPE,

3437: END Maintain_wf_pending_flag ;
3438:
3439:
3440: PROCEDURE Set_Asgmt_wf_result_Status
3441: (p_assignment_id IN pa_project_assignments.assignment_id%TYPE,
3442: p_status_code IN pa_project_statuses.project_status_code%TYPE,
3443: p_result_type IN VARCHAR2,
3444: p_item_type IN VARCHAR2,
3445: p_item_key IN VARCHAR2,

Line 3462: pa_project_assignments

3458: NO_ASSIGNMENT_ID EXCEPTION;
3459:
3460: CURSOR l_get_record_version_csr IS
3461: SELECT record_version_number FROM
3462: pa_project_assignments
3463: WHERE assignment_id = p_assignment_id;
3464:
3465: BEGIN
3466: OPEN l_get_record_version_csr;

Line 3748: l_assignment_id pa_project_assignments.assignment_id%TYPE;

3744: , actid IN NUMBER
3745: , funcmode IN VARCHAR2
3746: , resultout OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3747: IS
3748: l_assignment_id pa_project_assignments.assignment_id%TYPE;
3749:
3750: BEGIN
3751: -- Call the set_approver_comments procedure.
3752: -- Since populate_approval_NF_comments is being called from the

Line 4380: PROCEDURE Delete_Assignment_WF_Records (p_assignment_id IN pa_project_assignments.assignment_id%TYPE,

4376: END Set_NF_Subject_and_Desc ;
4377:
4378:
4379:
4380: PROCEDURE Delete_Assignment_WF_Records (p_assignment_id IN pa_project_assignments.assignment_id%TYPE,
4381: p_project_id IN pa_project_assignments.project_id%TYPE)
4382: IS
4383:
4384: /*CURSOR get_project_id IS

Line 4381: p_project_id IN pa_project_assignments.project_id%TYPE)

4377:
4378:
4379:
4380: PROCEDURE Delete_Assignment_WF_Records (p_assignment_id IN pa_project_assignments.assignment_id%TYPE,
4381: p_project_id IN pa_project_assignments.project_id%TYPE)
4382: IS
4383:
4384: /*CURSOR get_project_id IS
4385: SELECT project_id

Line 4386: FROM pa_project_assignments

4382: IS
4383:
4384: /*CURSOR get_project_id IS
4385: SELECT project_id
4386: FROM pa_project_assignments
4387: WHERE assignment_id = p_assignment_id;
4388:
4389: l_project_id pa_project_assignments.project_id%TYPE;*/
4390:

Line 4389: l_project_id pa_project_assignments.project_id%TYPE;*/

4385: SELECT project_id
4386: FROM pa_project_assignments
4387: WHERE assignment_id = p_assignment_id;
4388:
4389: l_project_id pa_project_assignments.project_id%TYPE;*/
4390:
4391: BEGIN
4392:
4393: /*OPEN get_project_id;

Line 4560: pa_project_assignments asmt

4556: BEGIN
4557: SELECT count(object_id1)
4558: INTO l_number_of_assignments
4559: FROM pa_wf_ntf_performers pf,
4560: pa_project_assignments asmt
4561: WHERE pf.group_id = p_group_id
4562: AND pf.approver_group_id = p_approver_group_id
4563: AND pf.routing_order = p_routing_order
4564: AND pf.object_id1 = asmt.assignment_id

Line 4833: l_aprvl_status pa_project_assignments.apprvl_status_code%TYPE;

4829:
4830: l_asgmt_details_url VARCHAR2(600);
4831: l_resource_schedules_url VARCHAR2(600);
4832: l_reapproval_flag VARCHAR2(1);
4833: l_aprvl_status pa_project_assignments.apprvl_status_code%TYPE;
4834: l_override_basis_name VARCHAR2(80) := NULL;
4835: l_resource_start_date DATE;
4836:
4837: CURSOR l_prev_asgmt_info_csr (l_assignment_id IN NUMBER)

Line 4868: FROM pa_project_assignments_v ppa

4864: ppa.tp_percent_applied_override,
4865: ppa.work_type_name,
4866: ppa.transfer_price_rate, -- Added for bug 3051110
4867: ppa.transfer_pr_rate_curr
4868: FROM pa_project_assignments_v ppa
4869: WHERE assignment_id = p_assignment_id;
4870:
4871: CURSOR csr_get_override_basis_name (p_override_basis_code IN VARCHAR2) IS
4872: SELECT plks.meaning

Line 4946: UPDATE pa_project_assignments

4942:
4943: ---------------------------
4944: --Set the mass wf flag
4945: ---------------------------
4946: UPDATE pa_project_assignments
4947: SET mass_wf_in_progress_flag = 'N'
4948: WHERE assignment_id = p_assignment_id;
4949:
4950: log_message('After setting mass wf flag');

Line 4954: FROM pa_project_assignments

4950: log_message('After setting mass wf flag');
4951:
4952: SELECT resource_id
4953: INTO l_resource_id
4954: FROM pa_project_assignments
4955: WHERE assignment_id = p_assignment_id;
4956:
4957: log_message('After getting resource_id:'|| l_resource_id);
4958:

Line 4965: FROM pa_project_assignments

4961: --------------------------------------------------------------
4962: --Getting recepients approval type
4963: SELECT apprvl_status_code
4964: INTO l_aprvl_status
4965: FROM pa_project_assignments
4966: WHERE assignment_id = p_assignment_id;
4967:
4968: log_message('After getting recepients approval type:' || l_aprvl_status);
4969:

Line 5533: FROM pa_project_assignments_v ppa,

5529: ppa.tp_calc_base_code_override,
5530: ppa.tp_percent_applied_override,
5531: ppa.work_type_name,
5532: hr.name
5533: FROM pa_project_assignments_v ppa,
5534: pa_resources_denorm res,
5535: hr_all_organization_units hr
5536: WHERE ppa.assignment_id = l_assignment_id
5537: AND res.resource_id = ppa.resource_id

Line 5937: l_aprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;

5933: l_num_apr_asgns NUMBER ;
5934: l_num_rej_asgns NUMBER ;
5935: l_display_name wf_users.display_name%TYPE; --VARCHAR2(360); Commented VARCHAR2(360) for bug 3267790 --Commented VARCHAR2(200) for bug 3311991
5936: l_approver_name wf_users.display_name%TYPE; --VARCHAR2(320); Commented VARCHAR2(320) for bug 3267790 --Commented VARCHAR2(200) for bug 3311991
5937: l_aprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
5938: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;
5939:
5940: CURSOR Resource_Manager IS
5941: SELECT distinct res.manager_id

Line 5943: pa_project_assignments asgn,

5939:
5940: CURSOR Resource_Manager IS
5941: SELECT distinct res.manager_id
5942: FROM pa_resources_denorm res,
5943: pa_project_assignments asgn,
5944: pa_wf_ntf_performers ntf,
5945: fnd_user fnd
5946: WHERE ntf.group_id = p_group_id
5947: AND asgn.assignment_id = l_assignment_id

Line 5964: pa_project_assignments asgn,

5960: pa_resources_denorm res,
5961: /* Commenting this for performance tuning Bug#2499051
5962: (select pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') menu_id
5963: from dual) temp, */
5964: pa_project_assignments asgn,
5965: pa_wf_ntf_performers ntf,
5966: wf_roles wf,
5967: per_all_people_f per
5968: WHERE ntf.group_id = p_group_id

Line 6079: FROM pa_project_assignments

6075:
6076: --Getting recepients approval type
6077: SELECT apprvl_status_code
6078: INTO l_aprvl_status_code
6079: FROM pa_project_assignments
6080: WHERE assignment_id = l_assignment_id_tbl(i);
6081:
6082: IF l_aprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved THEN
6083: l_notification_type := 'APPROVAL_FYI';

Line 6468: l_project_id pa_project_assignments.project_id%TYPE;

6464: x_return_status VARCHAR2(1);
6465: x_msg_count NUMBER;
6466: x_msg_data VARCHAR2(2000);
6467:
6468: l_project_id pa_project_assignments.project_id%TYPE;
6469: l_mode VARCHAR2(30);
6470: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6471: l_approval_status_tbl SYSTEM.pa_varchar2_30_tbl_type:= SYSTEM.pa_varchar2_30_tbl_type();
6472: l_group_id NUMBER;

Line 6649: FROM pa_project_assignments

6645: IS
6646:
6647: CURSOR get_status_and_rec_num IS
6648: SELECT record_version_number
6649: FROM pa_project_assignments
6650: WHERE assignment_id = p_assignment_id;
6651:
6652: CURSOR get_assignment_status IS
6653: SELECT approval_status

Line 6673: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row (

6669: OPEN get_assignment_status;
6670: FETCH get_assignment_status INTO l_apprvl_status_code ;
6671: CLOSE get_assignment_status;
6672:
6673: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row (
6674: p_assignment_id => p_assignment_id
6675: ,p_record_version_number => l_record_version_number
6676: ,p_apprvl_status_code => l_apprvl_status_code
6677: ,x_return_status => l_return_status );

Line 6693: UPDATE pa_project_assignments

6689:
6690: ---------------------------
6691: --Set the mass wf flag
6692: ---------------------------
6693: UPDATE pa_project_assignments
6694: SET mass_wf_in_progress_flag = 'N'
6695: WHERE assignment_id = p_assignment_id;
6696:
6697: EXCEPTION

Line 6710: ,p_approval_status IN pa_project_assignments.apprvl_status_code%TYPE

6706: --tasks
6707: -----------------------------------------------------------
6708: PROCEDURE process_assignment_tasks (
6709: p_assignment_id IN NUMBER
6710: ,p_approval_status IN pa_project_assignments.apprvl_status_code%TYPE
6711: ,p_action_code IN VARCHAR2
6712: ,p_conflict_group_id IN NUMBER
6713: ,p_project_id IN NUMBER
6714: ,p_mode IN VARCHAR2

Line 6728: l_aprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;

6724: IS
6725: PRAGMA AUTONOMOUS_TRANSACTION;
6726:
6727: l_change_id NUMBER;
6728: l_aprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
6729: l_resource_id NUMBER;
6730: l_submitter_user_id NUMBER;
6731: l_record_version_number1 NUMBER;
6732: l_record_version_number2 NUMBER;

Line 6748: FROM pa_project_assignments

6744: l_pending_approvals pending_approvals%ROWTYPE;
6745:
6746: CURSOR get_rec_num ( p_assignment_id IN NUMBER )IS
6747: SELECT record_version_number
6748: FROM pa_project_assignments
6749: WHERE assignment_id = p_assignment_id;
6750:
6751: BEGIN
6752:

Line 6829: FROM pa_project_assignments

6825: WHERE user_name = p_submitter_user_name;
6826:
6827: SELECT resource_id
6828: INTO l_resource_id
6829: FROM pa_project_assignments
6830: WHERE assignment_id = p_assignment_id;
6831:
6832: --Revert assignment status back to Working or Requires Re-submission
6833: Revert_assignment_status(

Line 6894: l_approval_status pa_project_assignments.apprvl_status_code%TYPE;

6890: ,p_update_info_doc IN VARCHAR2
6891: ,p_forwarded_from IN VARCHAR2
6892: ,p_note_to_approvers IN VARCHAR2)
6893: IS
6894: l_approval_status pa_project_assignments.apprvl_status_code%TYPE;
6895: l_aprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
6896: l_change_id NUMBER;
6897: l_action_code VARCHAR2(30);
6898: l_approver_group_id NUMBER;

Line 6895: l_aprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;

6891: ,p_forwarded_from IN VARCHAR2
6892: ,p_note_to_approvers IN VARCHAR2)
6893: IS
6894: l_approval_status pa_project_assignments.apprvl_status_code%TYPE;
6895: l_aprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
6896: l_change_id NUMBER;
6897: l_action_code VARCHAR2(30);
6898: l_approver_group_id NUMBER;
6899: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 6914: pa_project_assignments asgn

6910: /* Commented and altered as below for bug 5595003
6911: CURSOR distinct_approvers IS
6912: SELECT distinct user_name
6913: FROM pa_wf_ntf_performers ntf,
6914: pa_project_assignments asgn
6915: WHERE ntf.group_id = p_group_id
6916: AND ntf.object_id1 = asgn.assignment_id
6917: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted
6918: AND ntf.routing_order = p_routing_order + 1; */

Line 6923: pa_project_assignments asgn,

6919:
6920: CURSOR distinct_approvers IS
6921: SELECT distinct ntf.user_name
6922: FROM pa_wf_ntf_performers ntf,
6923: pa_project_assignments asgn,
6924: pa_wf_ntf_performers ntf1
6925: WHERE ntf.group_id = p_group_id
6926: AND ntf.object_id1 = asgn.assignment_id
6927: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted

Line 6937: pa_project_assignments asgn

6933:
6934: CURSOR pending_txn_approvals IS
6935: SELECT 'Y'
6936: FROM pa_wf_ntf_performers ntf,
6937: pa_project_assignments asgn
6938: WHERE ntf.group_id = p_group_id
6939: AND ntf.object_id1 = asgn.assignment_id
6940: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;
6941:

Line 7166: FROM pa_project_assignments

7162:
7163: BEGIN
7164: SELECT apprvl_status_code
7165: INTO l_approval_status
7166: FROM pa_project_assignments
7167: WHERE assignment_id = l_assignment_id_tbl(i);
7168: EXCEPTION
7169: WHEN NO_DATA_FOUND THEN
7170: null;

Line 7337: FROM pa_project_assignments_v ppa,

7333: ppa.tp_calc_base_code_override,
7334: ppa.tp_percent_applied_override,
7335: ppa.work_type_name,
7336: hr.name
7337: FROM pa_project_assignments_v ppa,
7338: pa_resources_denorm res,
7339: hr_all_organization_units hr
7340: WHERE assignment_id = l_assignment_id
7341: AND res.resource_id = ppa.resource_id

Line 7851: l_project_id pa_project_assignments.project_id%TYPE;

7847: ,funcmode IN VARCHAR2
7848: ,resultout OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
7849: IS
7850:
7851: l_project_id pa_project_assignments.project_id%TYPE;
7852: l_mode VARCHAR2(30);
7853: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7854: l_approval_status_tbl SYSTEM.pa_varchar2_30_tbl_type:= SYSTEM.pa_varchar2_30_tbl_type();
7855: l_group_id NUMBER;

Line 7869: pa_project_assignments asgn

7865:
7866: CURSOR pending_txn_approvals IS
7867: SELECT 'Y'
7868: FROM pa_wf_ntf_performers ntf,
7869: pa_project_assignments asgn
7870: WHERE ntf.group_id = l_group_id
7871: AND ntf.approver_group_id = l_approver_group_id --uncommented this line for Bug#5662785
7872: AND ntf.routing_order = l_routing_order
7873: AND ntf.user_name = l_ntfy_apprvl_recip_name -- added for bug 5488496

Line 7939: pa_project_assignments asgn

7935:
7936: SELECT ntf.object_id1
7937: BULK COLLECT INTO l_assignment_id_tbl
7938: FROM pa_wf_ntf_performers ntf,
7939: pa_project_assignments asgn
7940: WHERE ntf.group_id = l_group_id
7941: AND ntf.approver_group_id = l_approver_group_id
7942: AND ntf.routing_order = l_routing_order
7943: AND ntf.object_id1 = asgn.assignment_id

Line 8112: pa_project_assignments asgn

8108:
8109: SELECT ntf.object_id1
8110: BULK COLLECT INTO l_assignment_id_tbl
8111: FROM pa_wf_ntf_performers ntf,
8112: pa_project_assignments asgn
8113: WHERE ntf.group_id = l_group_id
8114: AND ntf.routing_order = 1
8115: AND ntf.object_id1 = asgn.assignment_id
8116: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;

Line 8137: FROM pa_project_assignments

8133: WHERE user_name = l_submitter_uname;
8134:
8135: SELECT resource_id
8136: INTO l_resource_id
8137: FROM pa_project_assignments
8138: WHERE assignment_id = l_assignment_id_tbl(i);
8139:
8140: --Revert assignment status back to previous status before approval
8141: Revert_assignment_status(