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_BUDGET_CORE1 dependencies on PA_RESOURCE_LIST_MEMBERS

Line 129: pa_resource_list_members m

125: m.resource_id,
126: m.track_as_labor_flag
127: from pa_periods p,
128: pa_tasks t,
129: pa_resource_list_members m
130: where m.resource_list_id = x_resource_list_id
131: and nvl(m.migration_code, 'M') = 'M'
132: and not exists
133: (select 1

Line 134: from pa_resource_list_members m1

130: where m.resource_list_id = x_resource_list_id
131: and nvl(m.migration_code, 'M') = 'M'
132: and not exists
133: (select 1
134: from pa_resource_list_members m1
135: where m1.parent_member_id =
136: m.resource_list_member_id)
137: and t.project_id = x_project_id
138: and not exists

Line 159: pa_resource_list_members m

155: m.track_as_labor_flag
156: from gl_period_statuses p,
157: pa_implementations i,
158: pa_tasks t,
159: pa_resource_list_members m
160: where m.resource_list_id = x_resource_list_id
161: and not exists
162: (select 1
163: from pa_resource_list_members m1

Line 163: from pa_resource_list_members m1

159: pa_resource_list_members m
160: where m.resource_list_id = x_resource_list_id
161: and not exists
162: (select 1
163: from pa_resource_list_members m1
164: where m1.parent_member_id =
165: m.resource_list_member_id)
166: and t.project_id = x_project_id
167: and not exists

Line 213: FROM PA_RESOURCE_LIST_MEMBERS PRLM

209: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
210: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
211: ( -- Fetch both 2nd level and group level resource list member
212: SELECT PRLM.RESOURCE_LIST_MEMBER_ID
213: FROM PA_RESOURCE_LIST_MEMBERS PRLM
214: WHERE (prlm.resource_list_member_id = x_resource_list_member_id
215: or
216: PRLM.PARENT_MEMBER_ID = x_resource_list_member_id )
217: )

Line 261: FROM PA_RESOURCE_LIST_MEMBERS PRLM

257: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
258: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
259: ( -- Fetch both 2nd level and group level resource list member
260: SELECT PRLM.RESOURCE_LIST_MEMBER_ID
261: FROM PA_RESOURCE_LIST_MEMBERS PRLM
262: WHERE (prlm.resource_list_member_id = x_resource_list_member_id
263: or
264: PRLM.PARENT_MEMBER_ID = x_resource_list_member_id)
265: )

Line 372: pa_resource_list_members m,

368: into x_uncat_res_list_member_id,
369: x_uncat_track_as_labor_flag,
370: x_uncat_unit_of_measure
371: from pa_resources r,
372: pa_resource_list_members m,
373: pa_implementations i,
374: pa_resource_lists l
375: where l.uncategorized_flag = 'Y'
376: and l.resource_list_id = m.resource_list_id

Line 396: pa_resource_list_members m,

392: into x_uncat_res_list_member_id,
393: x_uncat_track_as_labor_flag,
394: x_uncat_unit_of_measure
395: from pa_resources r,
396: pa_resource_list_members m,
397: pa_implementations i,
398: pa_resource_lists l
399: where l.uncategorized_flag = 'Y'
400: and l.resource_list_id = m.resource_list_id

Line 695: pa_resource_list_members p1,

691: where pbl.resource_assignment_id in (
692: select distinct pbl1.resource_assignment_id
693: from pa_budget_lines pbl1,
694: pa_resource_assignments pra,
695: pa_resource_list_members p1,
696: pa_resource_list_members p2
697: where pra.resource_list_member_id = p2.resource_list_member_id
698: and p1.parent_member_id = p2.resource_list_member_id
699: and p1.resource_list_member_id = x_uncat_res_list_member_id

Line 696: pa_resource_list_members p2

692: select distinct pbl1.resource_assignment_id
693: from pa_budget_lines pbl1,
694: pa_resource_assignments pra,
695: pa_resource_list_members p1,
696: pa_resource_list_members p2
697: where pra.resource_list_member_id = p2.resource_list_member_id
698: and p1.parent_member_id = p2.resource_list_member_id
699: and p1.resource_list_member_id = x_uncat_res_list_member_id
700: and pbl1.resource_assignment_id = pra.resource_assignment_id

Line 1079: pa_resource_list_members m

1075: l_resource_list_member_id,
1076: l_resource_id,
1077: l_track_as_labor_flag
1078: from pa_periods p,
1079: pa_resource_list_members m
1080: where m.resource_list_id = x_resource_list_id
1081: and nvl(m.migration_code, 'M') = 'M'
1082: and not exists
1083: (select 1

Line 1084: from pa_resource_list_members m1

1080: where m.resource_list_id = x_resource_list_id
1081: and nvl(m.migration_code, 'M') = 'M'
1082: and not exists
1083: (select 1
1084: from pa_resource_list_members m1
1085: where m1.parent_member_id = m.resource_list_member_id)
1086: and p.start_date between x_start_period_start_date
1087: and x_end_period_end_date;
1088:

Line 1127: FROM PA_RESOURCE_LIST_MEMBERS PRLM

1123: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
1124: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
1125: ( -- Fetch both 2nd level and group level resource list member
1126: SELECT PRLM.RESOURCE_LIST_MEMBER_ID
1127: FROM PA_RESOURCE_LIST_MEMBERS PRLM
1128: WHERE (prlm.resource_list_member_id = l_RESOURCE_LIST_MEMBER_ID(i)
1129: or
1130: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
1131: )

Line 1176: pa_resource_list_members m

1172: l_resource_id,
1173: l_track_as_labor_flag
1174: from gl_period_statuses p,
1175: pa_implementations i,
1176: pa_resource_list_members m
1177: where m.resource_list_id = x_resource_list_id
1178: and not exists
1179: (select 1
1180: from pa_resource_list_members m1

Line 1180: from pa_resource_list_members m1

1176: pa_resource_list_members m
1177: where m.resource_list_id = x_resource_list_id
1178: and not exists
1179: (select 1
1180: from pa_resource_list_members m1
1181: where m1.parent_member_id = m.resource_list_member_id)
1182: and p.application_id = pa_period_process_pkg.application_id
1183: and p.set_of_books_id = i.set_of_books_id
1184: and p.adjustment_period_flag = 'N'

Line 1226: FROM PA_RESOURCE_LIST_MEMBERS PRLM

1222: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
1223: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
1224: ( -- Fetch both 2nd level and group level resource list member
1225: SELECT PRLM.RESOURCE_LIST_MEMBER_ID
1226: FROM PA_RESOURCE_LIST_MEMBERS PRLM
1227: WHERE (prlm.resource_list_member_id = l_RESOURCE_LIST_MEMBER_ID(i)
1228: or
1229: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
1230: )

Line 1324: pa_resource_list_members p1,

1320: where pbl.resource_assignment_id in (
1321: select distinct pbl1.resource_assignment_id
1322: from pa_budget_lines pbl1,
1323: pa_resource_assignments pra,
1324: pa_resource_list_members p1,
1325: pa_resource_list_members p2
1326: where pra.resource_list_member_id = p2.resource_list_member_id
1327: and p1.parent_member_id = p2.resource_list_member_id
1328: and p1.resource_list_member_id = TmpActTab(j).resource_list_member_id

Line 1325: pa_resource_list_members p2

1321: select distinct pbl1.resource_assignment_id
1322: from pa_budget_lines pbl1,
1323: pa_resource_assignments pra,
1324: pa_resource_list_members p1,
1325: pa_resource_list_members p2
1326: where pra.resource_list_member_id = p2.resource_list_member_id
1327: and p1.parent_member_id = p2.resource_list_member_id
1328: and p1.resource_list_member_id = TmpActTab(j).resource_list_member_id
1329: and pbl1.resource_assignment_id = pra.resource_assignment_id

Line 1521: from pa_resource_list_members m

1517: /* commenting part for project level, categorized
1518: for res_rec in (select m.resource_list_member_id,
1519: m.resource_id,
1520: m.track_as_labor_flag
1521: from pa_resource_list_members m
1522: where m.resource_list_id = x_resource_list_id
1523: and nvl(m.migration_code, 'M') = 'M'
1524: and not exists
1525: (select 1

Line 1526: from pa_resource_list_members m1

1522: where m.resource_list_id = x_resource_list_id
1523: and nvl(m.migration_code, 'M') = 'M'
1524: and not exists
1525: (select 1
1526: from pa_resource_list_members m1
1527: where m1.parent_member_id =
1528: m.resource_list_member_id)
1529: ) loop
1530:

Line 1921: pa_resource_list_members p1,

1917: where pbl.resource_assignment_id in (
1918: select distinct pbl1.resource_assignment_id
1919: from pa_budget_lines pbl1,
1920: pa_resource_assignments pra,
1921: pa_resource_list_members p1,
1922: pa_resource_list_members p2
1923: where pra.resource_list_member_id = p2.resource_list_member_id
1924: and p1.parent_member_id = p2.resource_list_member_id
1925: and p1.resource_list_member_id = x_uncat_res_list_member_id

Line 1922: pa_resource_list_members p2

1918: select distinct pbl1.resource_assignment_id
1919: from pa_budget_lines pbl1,
1920: pa_resource_assignments pra,
1921: pa_resource_list_members p1,
1922: pa_resource_list_members p2
1923: where pra.resource_list_member_id = p2.resource_list_member_id
1924: and p1.parent_member_id = p2.resource_list_member_id
1925: and p1.resource_list_member_id = x_uncat_res_list_member_id
1926: and pbl1.resource_assignment_id = pra.resource_assignment_id

Line 2132: pa_resource_list_members m

2128: l_resource_id,
2129: l_track_as_labor_flag
2130: from pa_periods p,
2131: pa_tasks t,
2132: pa_resource_list_members m
2133: where m.resource_list_id = x_resource_list_id
2134: and nvl(m.migration_code, 'M') = 'M'
2135: and not exists
2136: (select 1

Line 2137: from pa_resource_list_members m1

2133: where m.resource_list_id = x_resource_list_id
2134: and nvl(m.migration_code, 'M') = 'M'
2135: and not exists
2136: (select 1
2137: from pa_resource_list_members m1
2138: where m1.parent_member_id =
2139: m.resource_list_member_id)
2140: and t.project_id = x_project_id
2141: and t.task_id = t.top_task_id

Line 2193: FROM PA_RESOURCE_LIST_MEMBERS PRLM

2189: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
2190: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
2191: ( -- Fetch both 2nd level and group level resource list member
2192: SELECT PRLM.RESOURCE_LIST_MEMBER_ID
2193: FROM PA_RESOURCE_LIST_MEMBERS PRLM
2194: WHERE (prlm.resource_list_member_id = l_RESOURCE_LIST_MEMBER_ID(i)
2195: or
2196: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
2197: )

Line 2248: pa_resource_list_members m

2244: l_track_as_labor_flag
2245: from gl_period_statuses p,
2246: pa_implementations i,
2247: pa_tasks t,
2248: pa_resource_list_members m
2249: where m.resource_list_id = x_resource_list_id
2250: and not exists
2251: (select 1
2252: from pa_resource_list_members m1

Line 2252: from pa_resource_list_members m1

2248: pa_resource_list_members m
2249: where m.resource_list_id = x_resource_list_id
2250: and not exists
2251: (select 1
2252: from pa_resource_list_members m1
2253: where m1.parent_member_id =
2254: m.resource_list_member_id)
2255: and t.project_id = x_project_id
2256: and t.task_id = t.top_task_id

Line 2321: FROM PA_RESOURCE_LIST_MEMBERS PRLM

2317: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
2318: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
2319: ( -- Fetch both 2nd level and group level resource list member
2320: SELECT PRLM.RESOURCE_LIST_MEMBER_ID
2321: FROM PA_RESOURCE_LIST_MEMBERS PRLM
2322: WHERE (prlm.resource_list_member_id = l_RESOURCE_LIST_MEMBER_ID(i)
2323: or
2324: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
2325: )

Line 2442: pa_resource_list_members p1,

2438: where pbl.resource_assignment_id in (
2439: select distinct pbl1.resource_assignment_id
2440: from pa_budget_lines pbl1,
2441: pa_resource_assignments pra,
2442: pa_resource_list_members p1,
2443: pa_resource_list_members p2
2444: where pra.resource_list_member_id = p2.resource_list_member_id
2445: and p1.parent_member_id = p2.resource_list_member_id
2446: and p1.resource_list_member_id = TmpActTab(i).resource_list_member_id

Line 2443: pa_resource_list_members p2

2439: select distinct pbl1.resource_assignment_id
2440: from pa_budget_lines pbl1,
2441: pa_resource_assignments pra,
2442: pa_resource_list_members p1,
2443: pa_resource_list_members p2
2444: where pra.resource_list_member_id = p2.resource_list_member_id
2445: and p1.parent_member_id = p2.resource_list_member_id
2446: and p1.resource_list_member_id = TmpActTab(i).resource_list_member_id
2447: and pbl1.resource_assignment_id = pra.resource_assignment_id

Line 2805: from pa_resource_list_members m

2801: -- top level task, categorized
2802: for res_rec in (select m.resource_list_member_id,
2803: m.resource_id,
2804: m.track_as_labor_flag
2805: from pa_resource_list_members m
2806: where m.resource_list_id =
2807: x_resource_list_id
2808: and nvl(m.migration_code, 'M') = 'M'
2809: and not exists

Line 2811: from pa_resource_list_members m1

2807: x_resource_list_id
2808: and nvl(m.migration_code, 'M') = 'M'
2809: and not exists
2810: (select 1
2811: from pa_resource_list_members m1
2812: where m1.parent_member_id =
2813: m.resource_list_member_id)
2814: ) loop
2815:

Line 3224: pa_resource_list_members p1,

3220: where pbl.resource_assignment_id in (
3221: select distinct pbl1.resource_assignment_id
3222: from pa_budget_lines pbl1,
3223: pa_resource_assignments pra,
3224: pa_resource_list_members p1,
3225: pa_resource_list_members p2
3226: where pra.resource_list_member_id = p2.resource_list_member_id
3227: and p1.parent_member_id = p2.resource_list_member_id
3228: and p1.resource_list_member_id = x_uncat_res_list_member_id

Line 3225: pa_resource_list_members p2

3221: select distinct pbl1.resource_assignment_id
3222: from pa_budget_lines pbl1,
3223: pa_resource_assignments pra,
3224: pa_resource_list_members p1,
3225: pa_resource_list_members p2
3226: where pra.resource_list_member_id = p2.resource_list_member_id
3227: and p1.parent_member_id = p2.resource_list_member_id
3228: and p1.resource_list_member_id = x_uncat_res_list_member_id
3229: and pbl1.resource_assignment_id = pra.resource_assignment_id

Line 3436: pa_resource_list_members m

3432: l_resource_id,
3433: l_track_as_labor_flag
3434: from pa_periods p,
3435: pa_tasks t,
3436: pa_resource_list_members m
3437: where m.resource_list_id = x_resource_list_id
3438: and nvl(m.migration_code, 'M') = 'M'
3439: and not exists
3440: (select 1

Line 3441: from pa_resource_list_members m1

3437: where m.resource_list_id = x_resource_list_id
3438: and nvl(m.migration_code, 'M') = 'M'
3439: and not exists
3440: (select 1
3441: from pa_resource_list_members m1
3442: where m1.parent_member_id =
3443: m.resource_list_member_id)
3444: and t.project_id = x_project_id
3445: and not exists

Line 3500: FROM PA_RESOURCE_LIST_MEMBERS PRLM

3496: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
3497: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
3498: ( -- Fetch both 2nd level and group level resource list member
3499: SELECT PRLM.RESOURCE_LIST_MEMBER_ID
3500: FROM PA_RESOURCE_LIST_MEMBERS PRLM
3501: WHERE (prlm.resource_list_member_id = l_RESOURCE_LIST_MEMBER_ID(i)
3502: or
3503: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
3504: )

Line 3555: pa_resource_list_members m

3551: l_track_as_labor_flag
3552: from gl_period_statuses p,
3553: pa_implementations i,
3554: pa_tasks t,
3555: pa_resource_list_members m
3556: where m.resource_list_id = x_resource_list_id
3557: and not exists
3558: (select 1
3559: from pa_resource_list_members m1

Line 3559: from pa_resource_list_members m1

3555: pa_resource_list_members m
3556: where m.resource_list_id = x_resource_list_id
3557: and not exists
3558: (select 1
3559: from pa_resource_list_members m1
3560: where m1.parent_member_id =
3561: m.resource_list_member_id)
3562: and t.project_id = x_project_id
3563: and not exists

Line 3619: FROM PA_RESOURCE_LIST_MEMBERS PRLM

3615: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
3616: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
3617: ( -- Fetch both 2nd level and group level resource list member
3618: SELECT PRLM.RESOURCE_LIST_MEMBER_ID
3619: FROM PA_RESOURCE_LIST_MEMBERS PRLM
3620: WHERE (prlm.resource_list_member_id = l_RESOURCE_LIST_MEMBER_ID(i)
3621: or
3622: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
3623: )

Line 3720: pa_resource_list_members p1,

3716: where pbl.resource_assignment_id in (
3717: select distinct pbl1.resource_assignment_id
3718: from pa_budget_lines pbl1,
3719: pa_resource_assignments pra,
3720: pa_resource_list_members p1,
3721: pa_resource_list_members p2
3722: where pra.resource_list_member_id = p2.resource_list_member_id
3723: and p1.parent_member_id = p2.resource_list_member_id
3724: and p1.resource_list_member_id = TmpActTab(j).resource_list_member_id

Line 3721: pa_resource_list_members p2

3717: select distinct pbl1.resource_assignment_id
3718: from pa_budget_lines pbl1,
3719: pa_resource_assignments pra,
3720: pa_resource_list_members p1,
3721: pa_resource_list_members p2
3722: where pra.resource_list_member_id = p2.resource_list_member_id
3723: and p1.parent_member_id = p2.resource_list_member_id
3724: and p1.resource_list_member_id = TmpActTab(j).resource_list_member_id
3725: and pbl1.resource_assignment_id = pra.resource_assignment_id

Line 4074: from pa_resource_list_members m

4070: -- lowest level task, categorized
4071: for res_rec in (select m.resource_list_member_id,
4072: m.resource_id,
4073: m.track_as_labor_flag
4074: from pa_resource_list_members m
4075: where m.resource_list_id =
4076: x_resource_list_id
4077: and nvl(m.migration_code, 'M') = 'M'
4078: and not exists

Line 4080: from pa_resource_list_members m1

4076: x_resource_list_id
4077: and nvl(m.migration_code, 'M') = 'M'
4078: and not exists
4079: (select 1
4080: from pa_resource_list_members m1
4081: where m1.parent_member_id =
4082: m.resource_list_member_id)
4083: ) loop
4084:

Line 4285: from pa_resource_list_members p1,

4281: IS
4282: --BUG 6509313 Start
4283: cursor get_parent_member(x_child_member_id number) is
4284: select p2.resource_list_member_id parent_member_id
4285: from pa_resource_list_members p1,
4286: pa_resource_list_members p2
4287: where p1.parent_member_id = p2.resource_list_member_id
4288: and p1.resource_list_member_id = x_child_member_id; -- child id
4289:

Line 4286: pa_resource_list_members p2

4282: --BUG 6509313 Start
4283: cursor get_parent_member(x_child_member_id number) is
4284: select p2.resource_list_member_id parent_member_id
4285: from pa_resource_list_members p1,
4286: pa_resource_list_members p2
4287: where p1.parent_member_id = p2.resource_list_member_id
4288: and p1.resource_list_member_id = x_child_member_id; -- child id
4289:
4290: cursor parent_amounts(l_parent_id number,