DBA Data[Home] [Help]

APPS.PA_BUDGET_ACCOUNT_PKG dependencies on PA_RESOURCE_ASSIGNMENTS

Line 207: PA_Resource_Assignments RA,

203: PA_Resource_Types RTYPE,
204: PA_Budget_Lines BL,
205: PA_Resources RS,
206: PA_Resource_List_Members RM,
207: PA_Resource_Assignments RA,
208: PA_Resource_Txn_Attributes RT,
209: PA_TASKS PT
210: WHERE
211: -- ra.Budget_Version_ID = P_Budget_Version_ID AND

Line 504: pa_resource_assignments pra

500:
501: select code_combination_id
502: into l_prev_ccid
503: from pa_budget_lines pbl,
504: pa_resource_assignments pra
505: where pra.budget_version_id = l_Prev_Budget_Version_ID
506: and pra.resource_list_member_id = bl.resource_list_member_id
507: and pra.project_id = p_project_id
508: and pra.task_id = bl.task_id

Line 1427: PA_Resource_Assignments RA1

1423: GLPRD.End_Date END_DATE
1424: FROM
1425: GL_Period_Statuses GLPRD,
1426: PA_Implementations IMP,
1427: PA_Resource_Assignments RA1
1428: WHERE
1429: GLPRD.Application_ID = PA_Period_Process_Pkg.Application_ID -- 101
1430: AND GLPRD.Set_Of_Books_ID = IMP.Set_Of_Books_ID
1431: AND GLPRD.Closing_status IN ('O','F')

Line 1448: PA_Resource_Assignments RA2,

1444: BL2.Start_Date START_DATE,
1445: BL2.End_Date END_DATE
1446: FROM
1447: PA_Budget_Lines BL2,
1448: PA_Resource_Assignments RA2,
1449: GL_Period_Statuses GLPRD2,
1450: PA_Implementations IMP2
1451: WHERE
1452: RA2.Resource_Assignment_ID = BL2.Resource_Assignment_ID

Line 1520: PA_Resource_Assignments RA

1516: t_GL_Start_Date,
1517: t_GL_End_Date
1518: FROM
1519: PA_Budget_Lines BL,
1520: PA_Resource_Assignments RA
1521: WHERE
1522: RA.Budget_Version_ID = p_Budget_Version_ID
1523: AND RA.Resource_Assignment_ID = BL.Resource_Assignment_ID ;
1524: