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:
95: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 684: FROM pa_resource_assignments

680: bug 3846278 */
681: -- hr_utility.trace('---ref start date before---'||to_char(l_reference_start_date,'dd-mon-rrrr'));
682:
683: SELECT NVL(rate_based_flag,'N') INTO l_rate_based_flag
684: FROM pa_resource_assignments
685: WHERE
686: resource_assignment_id = l_res_asg_id(i);
687:
688: IF l_rate_based_flag = 'N' THEN

Line 894: FROM pa_resource_assignments ra,

890:
891: -- Get other message token details
892: SELECT p.name, ta.task_number, rlm.alias
893: INTO l_project_name, l_task_number, l_resource_name
894: FROM pa_resource_assignments ra,
895: pa_projects_all p,
896: pa_tasks ta,
897: pa_resource_list_members rlm
898: WHERE ra.resource_assignment_id = l_res_asg_id(i)

Line 1119: pa_resource_assignments ra

1115:
1116: -- Get the target task billability flag
1117: SELECT NVL(billable_flag,'Y') INTO l_billable_flag
1118: FROM pa_tasks ta,
1119: pa_resource_assignments ra
1120: WHERE ra.resource_assignment_id = l_res_asg_id(i)
1121: AND ra.task_id = ta.task_id (+);
1122:
1123: INSERT INTO pa_fp_rollup_tmp(

Line 1733: FROM pa_resource_assignments src_ra,

1729: BULK COLLECT
1730: INTO l_sr_src_ra_id_tab,
1731: l_sr_tgt_ra_id_tab,
1732: l_sr_txn_currency_code_tab
1733: FROM pa_resource_assignments src_ra,
1734: pa_resource_assignments tgt_ra,
1735: pa_tasks ta,
1736: pa_fp_rollup_tmp cmt
1737: WHERE tgt_ra.resource_assignment_id = cmt.resource_assignment_id

Line 1734: pa_resource_assignments tgt_ra,

1730: INTO l_sr_src_ra_id_tab,
1731: l_sr_tgt_ra_id_tab,
1732: l_sr_txn_currency_code_tab
1733: FROM pa_resource_assignments src_ra,
1734: pa_resource_assignments tgt_ra,
1735: pa_tasks ta,
1736: pa_fp_rollup_tmp cmt
1737: WHERE tgt_ra.resource_assignment_id = cmt.resource_assignment_id
1738: AND ta.task_id (+) = NVL(tgt_ra.task_id,0) -- A. check billability