APPS.PA_FP_GEN_COMMITMENT_AMOUNTS dependencies on PA_RESOURCE_ASSIGNMENTS

Line 39: PA_RESOURCE_ASSIGNMENTS P

35: ,NVL(CT.ACCT_BURDENED_COST,0) tot_projfunc_burdened_cost
36: ,NVL(CT.TOT_CMT_QUANTITY,0) tot_quantity
37: FROM PA_COMMITMENT_TXNS CT,
38: PA_RES_LIST_MAP_TMP4 TMP,
39: PA_RESOURCE_ASSIGNMENTS P
40: WHERE TMP.TXN_SOURCE_ID = CT.CMT_LINE_ID
41: AND CT.PROJECT_ID = P_PROJECT_ID
42: AND NVL(CT.generation_error_flag,'N') = 'N'
43: AND P.RESOURCE_ASSIGNMENT_ID = TMP.TXN_RESOURCE_ASSIGNMENT_ID

Line 91: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;

87: l_msg_count NUMBER;
88: l_msg_data VARCHAR2(2000);
89: l_data VARCHAR2(2000);
90: l_msg_index_out NUMBER:=0;
91: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
92: l_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
93: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
94: l_cbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16827157
95:

Line 692: FROM pa_resource_assignments

688: bug 3846278 */
689: -- hr_utility.trace('---ref start date before---'||to_char(l_reference_start_date,'dd-mon-rrrr'));
690:
691: SELECT NVL(rate_based_flag,'N') INTO l_rate_based_flag
692: FROM pa_resource_assignments
693: WHERE
694: resource_assignment_id = l_res_asg_id(i);
695:
696: IF l_rate_based_flag = 'N' THEN

Line 902: FROM pa_resource_assignments ra,

898:
899: -- Get other message token details
900: SELECT p.name, ta.task_number, rlm.alias
901: INTO l_project_name, l_task_number, l_resource_name
902: FROM pa_resource_assignments ra,
903: pa_projects_all p,
904: pa_tasks ta,
905: pa_resource_list_members rlm
906: WHERE ra.resource_assignment_id = l_res_asg_id(i)

Line 1127: pa_resource_assignments ra

1123:
1124: -- Get the target task billability flag
1125: SELECT NVL(billable_flag,'Y') INTO l_billable_flag
1126: FROM pa_tasks ta,
1127: pa_resource_assignments ra
1128: WHERE ra.resource_assignment_id = l_res_asg_id(i)
1129: AND ra.task_id = ta.task_id (+);
1130:
1131: INSERT INTO pa_fp_rollup_tmp(

Line 1741: FROM pa_resource_assignments src_ra,

1737: BULK COLLECT
1738: INTO l_sr_src_ra_id_tab,
1739: l_sr_tgt_ra_id_tab,
1740: l_sr_txn_currency_code_tab
1741: FROM pa_resource_assignments src_ra,
1742: pa_resource_assignments tgt_ra,
1743: pa_tasks ta,
1744: pa_fp_rollup_tmp cmt
1745: WHERE tgt_ra.resource_assignment_id = cmt.resource_assignment_id

Line 1742: pa_resource_assignments tgt_ra,

1738: INTO l_sr_src_ra_id_tab,
1739: l_sr_tgt_ra_id_tab,
1740: l_sr_txn_currency_code_tab
1741: FROM pa_resource_assignments src_ra,
1742: pa_resource_assignments tgt_ra,
1743: pa_tasks ta,
1744: pa_fp_rollup_tmp cmt
1745: WHERE tgt_ra.resource_assignment_id = cmt.resource_assignment_id
1746: AND ta.task_id (+) = NVL(tgt_ra.task_id,0) -- A. check billability