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 2399: l_assignment_id pa_project_assignments.assignment_id%TYPE;

2395: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2396: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2397: l_number_of_recipients NUMBER := 0;
2398: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2399: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2400: l_project_id pa_projects_all.project_id%TYPE;
2401: l_approval_nf_rect_username VARCHAR2(100); /* Modified length from 30 to 100 for bug 3148857 */
2402: l_rect_person_id NUMBER := 0;
2403: l_recipient_type VARCHAR2(30);

Line 2639: l_assignment_id pa_project_assignments.assignment_id%TYPE;

2635: l_reject_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2636: l_out_reject_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2637: l_number_of_recipients NUMBER := 0;
2638: l_reject_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2639: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2640: l_project_id pa_projects_all.project_id%TYPE;
2641: l_reject_nf_rect_username wf_users.name%type; ---VARCHAR2(100); /* Modified length from 30 to 100 for bug 3148857 */ -- Changed for bug 3267790
2642: l_rect_person_id NUMBER := 0;
2643: l_recipient_type VARCHAR2(30);

Line 2877: l_assignment_id pa_project_assignments.assignment_id%TYPE;

2873: l_cancel_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2874: l_out_cancel_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2875: l_number_of_recipients NUMBER := 0;
2876: l_cancel_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2877: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2878: l_project_id pa_projects_all.project_id%TYPE;
2879: l_cancel_nf_rect_username wf_users.name%type; ----- VARCHAR2(30);Changed for bug 3267790
2880: --VARCHAR2(100); /* Modified length from 30 to 100 for bug 3148857 */
2881: l_rect_person_id NUMBER := 0;

Line 3173: l_assignment_type pa_project_assignments.assignment_type%TYPE;

3169: , actid IN NUMBER
3170: , funcmode IN VARCHAR2
3171: , resultout OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3172: IS
3173: l_assignment_type pa_project_assignments.assignment_type%TYPE;
3174: l_reapproval_flag VARCHAR2(1);
3175: BEGIN
3176: IF (funcmode <> wf_engine.eng_run) THEN
3177: resultout := wf_engine.eng_null;

Line 3372: l_assignment_id pa_project_assignments.assignment_id%TYPE;

3368: , actid IN NUMBER
3369: , funcmode IN VARCHAR2
3370: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
3371:
3372: l_assignment_id pa_project_assignments.assignment_id%TYPE;
3373: BEGIN
3374: l_assignment_id := wf_engine.GetItemAttrNumber
3375: (itemtype => itemtype,
3376: itemkey => itemkey,

Line 3415: UPDATE pa_project_assignments

3411: ELSE
3412: -- placeholder for any possible future values
3413: l_pending_approval_flag := 'N';
3414: END IF;
3415: UPDATE pa_project_assignments
3416: SET pending_approval_flag = l_pending_approval_flag,
3417: record_version_number = record_version_number + 1
3418: WHERE assignment_id = p_assignment_id;
3419: EXCEPTION

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

3422: END Maintain_wf_pending_flag ;
3423:
3424:
3425: PROCEDURE Set_Asgmt_wf_result_Status
3426: (p_assignment_id IN pa_project_assignments.assignment_id%TYPE,
3427: p_status_code IN pa_project_statuses.project_status_code%TYPE,
3428: p_result_type IN VARCHAR2,
3429: p_item_type IN VARCHAR2,
3430: p_item_key IN VARCHAR2,

Line 3447: pa_project_assignments

3443: NO_ASSIGNMENT_ID EXCEPTION;
3444:
3445: CURSOR l_get_record_version_csr IS
3446: SELECT record_version_number FROM
3447: pa_project_assignments
3448: WHERE assignment_id = p_assignment_id;
3449:
3450: BEGIN
3451: OPEN l_get_record_version_csr;

Line 3733: l_assignment_id pa_project_assignments.assignment_id%TYPE;

3729: , actid IN NUMBER
3730: , funcmode IN VARCHAR2
3731: , resultout OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3732: IS
3733: l_assignment_id pa_project_assignments.assignment_id%TYPE;
3734:
3735: BEGIN
3736: -- Call the set_approver_comments procedure.
3737: -- Since populate_approval_NF_comments is being called from the

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

4361: END Set_NF_Subject_and_Desc ;
4362:
4363:
4364:
4365: PROCEDURE Delete_Assignment_WF_Records (p_assignment_id IN pa_project_assignments.assignment_id%TYPE,
4366: p_project_id IN pa_project_assignments.project_id%TYPE)
4367: IS
4368:
4369: /*CURSOR get_project_id IS

Line 4366: p_project_id IN pa_project_assignments.project_id%TYPE)

4362:
4363:
4364:
4365: PROCEDURE Delete_Assignment_WF_Records (p_assignment_id IN pa_project_assignments.assignment_id%TYPE,
4366: p_project_id IN pa_project_assignments.project_id%TYPE)
4367: IS
4368:
4369: /*CURSOR get_project_id IS
4370: SELECT project_id

Line 4371: FROM pa_project_assignments

4367: IS
4368:
4369: /*CURSOR get_project_id IS
4370: SELECT project_id
4371: FROM pa_project_assignments
4372: WHERE assignment_id = p_assignment_id;
4373:
4374: l_project_id pa_project_assignments.project_id%TYPE;*/
4375:

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

4370: SELECT project_id
4371: FROM pa_project_assignments
4372: WHERE assignment_id = p_assignment_id;
4373:
4374: l_project_id pa_project_assignments.project_id%TYPE;*/
4375:
4376: BEGIN
4377:
4378: /*OPEN get_project_id;

Line 4545: pa_project_assignments asmt

4541: BEGIN
4542: SELECT count(object_id1)
4543: INTO l_number_of_assignments
4544: FROM pa_wf_ntf_performers pf,
4545: pa_project_assignments asmt
4546: WHERE pf.group_id = p_group_id
4547: AND pf.approver_group_id = p_approver_group_id
4548: AND pf.routing_order = p_routing_order
4549: AND pf.object_id1 = asmt.assignment_id

Line 4817: l_aprvl_status pa_project_assignments.apprvl_status_code%TYPE;

4813:
4814: l_asgmt_details_url VARCHAR2(600);
4815: l_resource_schedules_url VARCHAR2(600);
4816: l_reapproval_flag VARCHAR2(1);
4817: l_aprvl_status pa_project_assignments.apprvl_status_code%TYPE;
4818: l_override_basis_name VARCHAR2(80) := NULL;
4819: l_resource_start_date DATE;
4820:
4821: CURSOR l_prev_asgmt_info_csr (l_assignment_id IN NUMBER)

Line 4852: FROM pa_project_assignments_v ppa

4848: ppa.tp_percent_applied_override,
4849: ppa.work_type_name,
4850: ppa.transfer_price_rate, -- Added for bug 3051110
4851: ppa.transfer_pr_rate_curr
4852: FROM pa_project_assignments_v ppa
4853: WHERE assignment_id = p_assignment_id;
4854:
4855: CURSOR csr_get_override_basis_name (p_override_basis_code IN VARCHAR2) IS
4856: SELECT plks.meaning

Line 4930: UPDATE pa_project_assignments

4926:
4927: ---------------------------
4928: --Set the mass wf flag
4929: ---------------------------
4930: UPDATE pa_project_assignments
4931: SET mass_wf_in_progress_flag = 'N'
4932: WHERE assignment_id = p_assignment_id;
4933:
4934: log_message('After setting mass wf flag');

Line 4938: FROM pa_project_assignments

4934: log_message('After setting mass wf flag');
4935:
4936: SELECT resource_id
4937: INTO l_resource_id
4938: FROM pa_project_assignments
4939: WHERE assignment_id = p_assignment_id;
4940:
4941: log_message('After getting resource_id:'|| l_resource_id);
4942:

Line 4949: FROM pa_project_assignments

4945: --------------------------------------------------------------
4946: --Getting recepients approval type
4947: SELECT apprvl_status_code
4948: INTO l_aprvl_status
4949: FROM pa_project_assignments
4950: WHERE assignment_id = p_assignment_id;
4951:
4952: log_message('After getting recepients approval type:' || l_aprvl_status);
4953:

Line 5517: FROM pa_project_assignments_v ppa,

5513: ppa.tp_calc_base_code_override,
5514: ppa.tp_percent_applied_override,
5515: ppa.work_type_name,
5516: hr.name
5517: FROM pa_project_assignments_v ppa,
5518: pa_resources_denorm res,
5519: hr_all_organization_units hr
5520: WHERE ppa.assignment_id = l_assignment_id
5521: AND res.resource_id = ppa.resource_id

Line 5921: l_aprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;

5917: l_num_apr_asgns NUMBER ;
5918: l_num_rej_asgns NUMBER ;
5919: l_display_name wf_users.display_name%TYPE; --VARCHAR2(360); Commented VARCHAR2(360) for bug 3267790 --Commented VARCHAR2(200) for bug 3311991
5920: l_approver_name wf_users.display_name%TYPE; --VARCHAR2(320); Commented VARCHAR2(320) for bug 3267790 --Commented VARCHAR2(200) for bug 3311991
5921: l_aprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
5922: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;
5923:
5924: CURSOR Resource_Manager IS
5925: SELECT distinct res.manager_id

Line 5927: pa_project_assignments asgn,

5923:
5924: CURSOR Resource_Manager IS
5925: SELECT distinct res.manager_id
5926: FROM pa_resources_denorm res,
5927: pa_project_assignments asgn,
5928: pa_wf_ntf_performers ntf,
5929: fnd_user fnd
5930: WHERE ntf.group_id = p_group_id
5931: AND asgn.assignment_id = l_assignment_id

Line 5948: pa_project_assignments asgn,

5944: pa_resources_denorm res,
5945: /* Commenting this for performance tuning Bug#2499051
5946: (select pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') menu_id
5947: from dual) temp, */
5948: pa_project_assignments asgn,
5949: pa_wf_ntf_performers ntf,
5950: wf_roles wf,
5951: per_all_people_f per
5952: WHERE ntf.group_id = p_group_id

Line 6063: FROM pa_project_assignments

6059:
6060: --Getting recepients approval type
6061: SELECT apprvl_status_code
6062: INTO l_aprvl_status_code
6063: FROM pa_project_assignments
6064: WHERE assignment_id = l_assignment_id_tbl(i);
6065:
6066: IF l_aprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved THEN
6067: l_notification_type := 'APPROVAL_FYI';

Line 6452: l_project_id pa_project_assignments.project_id%TYPE;

6448: x_return_status VARCHAR2(1);
6449: x_msg_count NUMBER;
6450: x_msg_data VARCHAR2(2000);
6451:
6452: l_project_id pa_project_assignments.project_id%TYPE;
6453: l_mode VARCHAR2(30);
6454: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6455: l_approval_status_tbl SYSTEM.pa_varchar2_30_tbl_type:= SYSTEM.pa_varchar2_30_tbl_type();
6456: l_group_id NUMBER;

Line 6633: FROM pa_project_assignments

6629: IS
6630:
6631: CURSOR get_status_and_rec_num IS
6632: SELECT record_version_number
6633: FROM pa_project_assignments
6634: WHERE assignment_id = p_assignment_id;
6635:
6636: CURSOR get_assignment_status IS
6637: SELECT approval_status

Line 6657: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row (

6653: OPEN get_assignment_status;
6654: FETCH get_assignment_status INTO l_apprvl_status_code ;
6655: CLOSE get_assignment_status;
6656:
6657: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row (
6658: p_assignment_id => p_assignment_id
6659: ,p_record_version_number => l_record_version_number
6660: ,p_apprvl_status_code => l_apprvl_status_code
6661: ,x_return_status => l_return_status );

Line 6677: UPDATE pa_project_assignments

6673:
6674: ---------------------------
6675: --Set the mass wf flag
6676: ---------------------------
6677: UPDATE pa_project_assignments
6678: SET mass_wf_in_progress_flag = 'N'
6679: WHERE assignment_id = p_assignment_id;
6680:
6681: EXCEPTION

Line 6694: ,p_approval_status IN pa_project_assignments.apprvl_status_code%TYPE

6690: --tasks
6691: -----------------------------------------------------------
6692: PROCEDURE process_assignment_tasks (
6693: p_assignment_id IN NUMBER
6694: ,p_approval_status IN pa_project_assignments.apprvl_status_code%TYPE
6695: ,p_action_code IN VARCHAR2
6696: ,p_conflict_group_id IN NUMBER
6697: ,p_project_id IN NUMBER
6698: ,p_mode IN VARCHAR2

Line 6712: l_aprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;

6708: IS
6709: PRAGMA AUTONOMOUS_TRANSACTION;
6710:
6711: l_change_id NUMBER;
6712: l_aprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
6713: l_resource_id NUMBER;
6714: l_submitter_user_id NUMBER;
6715: l_record_version_number1 NUMBER;
6716: l_record_version_number2 NUMBER;

Line 6732: FROM pa_project_assignments

6728: l_pending_approvals pending_approvals%ROWTYPE;
6729:
6730: CURSOR get_rec_num ( p_assignment_id IN NUMBER )IS
6731: SELECT record_version_number
6732: FROM pa_project_assignments
6733: WHERE assignment_id = p_assignment_id;
6734:
6735: BEGIN
6736:

Line 6813: FROM pa_project_assignments

6809: WHERE user_name = p_submitter_user_name;
6810:
6811: SELECT resource_id
6812: INTO l_resource_id
6813: FROM pa_project_assignments
6814: WHERE assignment_id = p_assignment_id;
6815:
6816: --Revert assignment status back to Working or Requires Re-submission
6817: Revert_assignment_status(

Line 6878: l_approval_status pa_project_assignments.apprvl_status_code%TYPE;

6874: ,p_update_info_doc IN VARCHAR2
6875: ,p_forwarded_from IN VARCHAR2
6876: ,p_note_to_approvers IN VARCHAR2)
6877: IS
6878: l_approval_status pa_project_assignments.apprvl_status_code%TYPE;
6879: l_aprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
6880: l_change_id NUMBER;
6881: l_action_code VARCHAR2(30);
6882: l_approver_group_id NUMBER;

Line 6879: l_aprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;

6875: ,p_forwarded_from IN VARCHAR2
6876: ,p_note_to_approvers IN VARCHAR2)
6877: IS
6878: l_approval_status pa_project_assignments.apprvl_status_code%TYPE;
6879: l_aprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
6880: l_change_id NUMBER;
6881: l_action_code VARCHAR2(30);
6882: l_approver_group_id NUMBER;
6883: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 6898: pa_project_assignments asgn

6894: /* Commented and altered as below for bug 5595003
6895: CURSOR distinct_approvers IS
6896: SELECT distinct user_name
6897: FROM pa_wf_ntf_performers ntf,
6898: pa_project_assignments asgn
6899: WHERE ntf.group_id = p_group_id
6900: AND ntf.object_id1 = asgn.assignment_id
6901: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted
6902: AND ntf.routing_order = p_routing_order + 1; */

Line 6907: pa_project_assignments asgn,

6903:
6904: CURSOR distinct_approvers IS
6905: SELECT distinct ntf.user_name
6906: FROM pa_wf_ntf_performers ntf,
6907: pa_project_assignments asgn,
6908: pa_wf_ntf_performers ntf1
6909: WHERE ntf.group_id = p_group_id
6910: AND ntf.object_id1 = asgn.assignment_id
6911: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted

Line 6921: pa_project_assignments asgn

6917:
6918: CURSOR pending_txn_approvals IS
6919: SELECT 'Y'
6920: FROM pa_wf_ntf_performers ntf,
6921: pa_project_assignments asgn
6922: WHERE ntf.group_id = p_group_id
6923: AND ntf.object_id1 = asgn.assignment_id
6924: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;
6925:

Line 7150: FROM pa_project_assignments

7146:
7147: BEGIN
7148: SELECT apprvl_status_code
7149: INTO l_approval_status
7150: FROM pa_project_assignments
7151: WHERE assignment_id = l_assignment_id_tbl(i);
7152: EXCEPTION
7153: WHEN NO_DATA_FOUND THEN
7154: null;

Line 7321: FROM pa_project_assignments_v ppa,

7317: ppa.tp_calc_base_code_override,
7318: ppa.tp_percent_applied_override,
7319: ppa.work_type_name,
7320: hr.name
7321: FROM pa_project_assignments_v ppa,
7322: pa_resources_denorm res,
7323: hr_all_organization_units hr
7324: WHERE assignment_id = l_assignment_id
7325: AND res.resource_id = ppa.resource_id

Line 7835: l_project_id pa_project_assignments.project_id%TYPE;

7831: ,funcmode IN VARCHAR2
7832: ,resultout OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
7833: IS
7834:
7835: l_project_id pa_project_assignments.project_id%TYPE;
7836: l_mode VARCHAR2(30);
7837: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7838: l_approval_status_tbl SYSTEM.pa_varchar2_30_tbl_type:= SYSTEM.pa_varchar2_30_tbl_type();
7839: l_group_id NUMBER;

Line 7853: pa_project_assignments asgn

7849:
7850: CURSOR pending_txn_approvals IS
7851: SELECT 'Y'
7852: FROM pa_wf_ntf_performers ntf,
7853: pa_project_assignments asgn
7854: WHERE ntf.group_id = l_group_id
7855: AND ntf.approver_group_id = l_approver_group_id --uncommented this line for Bug#5662785
7856: AND ntf.routing_order = l_routing_order
7857: AND ntf.user_name = l_ntfy_apprvl_recip_name -- added for bug 5488496

Line 7923: pa_project_assignments asgn

7919:
7920: SELECT ntf.object_id1
7921: BULK COLLECT INTO l_assignment_id_tbl
7922: FROM pa_wf_ntf_performers ntf,
7923: pa_project_assignments asgn
7924: WHERE ntf.group_id = l_group_id
7925: AND ntf.approver_group_id = l_approver_group_id
7926: AND ntf.routing_order = l_routing_order
7927: AND ntf.object_id1 = asgn.assignment_id

Line 8096: pa_project_assignments asgn

8092:
8093: SELECT ntf.object_id1
8094: BULK COLLECT INTO l_assignment_id_tbl
8095: FROM pa_wf_ntf_performers ntf,
8096: pa_project_assignments asgn
8097: WHERE ntf.group_id = l_group_id
8098: AND ntf.routing_order = 1
8099: AND ntf.object_id1 = asgn.assignment_id
8100: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;

Line 8121: FROM pa_project_assignments

8117: WHERE user_name = l_submitter_uname;
8118:
8119: SELECT resource_id
8120: INTO l_resource_id
8121: FROM pa_project_assignments
8122: WHERE assignment_id = l_assignment_id_tbl(i);
8123:
8124: --Revert assignment status back to previous status before approval
8125: Revert_assignment_status(