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 214: pa_resource_list_members m,

210: into x_uncat_res_list_member_id,
211: x_uncat_track_as_labor_flag,
212: x_uncat_unit_of_measure
213: from pa_resources r,
214: pa_resource_list_members m,
215: pa_implementations i,
216: pa_resource_lists l
217: where l.uncategorized_flag = 'Y'
218: and l.resource_list_id = m.resource_list_id

Line 238: pa_resource_list_members m,

234: into x_uncat_res_list_member_id,
235: x_uncat_track_as_labor_flag,
236: x_uncat_unit_of_measure
237: from pa_resources r,
238: pa_resource_list_members m,
239: pa_implementations i,
240: pa_resource_lists l
241: where l.uncategorized_flag = 'Y'
242: and l.resource_list_id = m.resource_list_id

Line 531: pa_resource_list_members p1,

527: where pbl.resource_assignment_id in (
528: select distinct pbl1.resource_assignment_id
529: from pa_budget_lines pbl1,
530: pa_resource_assignments pra,
531: pa_resource_list_members p1,
532: pa_resource_list_members p2
533: where pra.resource_list_member_id = p2.resource_list_member_id
534: and p1.parent_member_id = p2.resource_list_member_id
535: and p1.resource_list_member_id = x_uncat_res_list_member_id

Line 532: pa_resource_list_members p2

528: select distinct pbl1.resource_assignment_id
529: from pa_budget_lines pbl1,
530: pa_resource_assignments pra,
531: pa_resource_list_members p1,
532: pa_resource_list_members p2
533: where pra.resource_list_member_id = p2.resource_list_member_id
534: and p1.parent_member_id = p2.resource_list_member_id
535: and p1.resource_list_member_id = x_uncat_res_list_member_id
536: and pbl1.resource_assignment_id = pra.resource_assignment_id

Line 883: pa_resource_list_members m

879: l_resource_list_member_id,
880: l_resource_id,
881: l_track_as_labor_flag
882: from pa_periods p,
883: pa_resource_list_members m
884: where m.resource_list_id = x_resource_list_id
885: and nvl(m.migration_code, 'M') = 'M'
886: and not exists
887: (select 1

Line 888: from pa_resource_list_members m1

884: where m.resource_list_id = x_resource_list_id
885: and nvl(m.migration_code, 'M') = 'M'
886: and not exists
887: (select 1
888: from pa_resource_list_members m1
889: where m1.parent_member_id = m.resource_list_member_id)
890: and p.start_date between x_start_period_start_date
891: and x_end_period_end_date;
892:

Line 931: FROM PA_RESOURCE_LIST_MEMBERS PRLM

927: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
928: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
929: ( -- Fetch both 2nd level and group level resource list member
930: SELECT PRLM.RESOURCE_LIST_MEMBER_ID
931: FROM PA_RESOURCE_LIST_MEMBERS PRLM
932: WHERE (prlm.resource_list_member_id = l_RESOURCE_LIST_MEMBER_ID(i)
933: or
934: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
935: )

Line 980: pa_resource_list_members m

976: l_resource_id,
977: l_track_as_labor_flag
978: from gl_period_statuses p,
979: pa_implementations i,
980: pa_resource_list_members m
981: where m.resource_list_id = x_resource_list_id
982: and not exists
983: (select 1
984: from pa_resource_list_members m1

Line 984: from pa_resource_list_members m1

980: pa_resource_list_members m
981: where m.resource_list_id = x_resource_list_id
982: and not exists
983: (select 1
984: from pa_resource_list_members m1
985: where m1.parent_member_id = m.resource_list_member_id)
986: and p.application_id = pa_period_process_pkg.application_id
987: and p.set_of_books_id = i.set_of_books_id
988: and p.adjustment_period_flag = 'N'

Line 1030: FROM PA_RESOURCE_LIST_MEMBERS PRLM

1026: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
1027: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
1028: ( -- Fetch both 2nd level and group level resource list member
1029: SELECT PRLM.RESOURCE_LIST_MEMBER_ID
1030: FROM PA_RESOURCE_LIST_MEMBERS PRLM
1031: WHERE (prlm.resource_list_member_id = l_RESOURCE_LIST_MEMBER_ID(i)
1032: or
1033: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
1034: )

Line 1123: pa_resource_list_members p1,

1119: where pbl.resource_assignment_id in (
1120: select distinct pbl1.resource_assignment_id
1121: from pa_budget_lines pbl1,
1122: pa_resource_assignments pra,
1123: pa_resource_list_members p1,
1124: pa_resource_list_members p2
1125: where pra.resource_list_member_id = p2.resource_list_member_id
1126: and p1.parent_member_id = p2.resource_list_member_id
1127: and p1.resource_list_member_id = TmpActTab(j).resource_list_member_id

Line 1124: pa_resource_list_members p2

1120: select distinct pbl1.resource_assignment_id
1121: from pa_budget_lines pbl1,
1122: pa_resource_assignments pra,
1123: pa_resource_list_members p1,
1124: pa_resource_list_members p2
1125: where pra.resource_list_member_id = p2.resource_list_member_id
1126: and p1.parent_member_id = p2.resource_list_member_id
1127: and p1.resource_list_member_id = TmpActTab(j).resource_list_member_id
1128: and pbl1.resource_assignment_id = pra.resource_assignment_id

Line 1289: from pa_resource_list_members m

1285: /* commenting part for project level, categorized
1286: for res_rec in (select m.resource_list_member_id,
1287: m.resource_id,
1288: m.track_as_labor_flag
1289: from pa_resource_list_members m
1290: where m.resource_list_id = x_resource_list_id
1291: and nvl(m.migration_code, 'M') = 'M'
1292: and not exists
1293: (select 1

Line 1294: from pa_resource_list_members m1

1290: where m.resource_list_id = x_resource_list_id
1291: and nvl(m.migration_code, 'M') = 'M'
1292: and not exists
1293: (select 1
1294: from pa_resource_list_members m1
1295: where m1.parent_member_id =
1296: m.resource_list_member_id)
1297: ) loop
1298:

Line 1683: pa_resource_list_members p1,

1679: where pbl.resource_assignment_id in (
1680: select distinct pbl1.resource_assignment_id
1681: from pa_budget_lines pbl1,
1682: pa_resource_assignments pra,
1683: pa_resource_list_members p1,
1684: pa_resource_list_members p2
1685: where pra.resource_list_member_id = p2.resource_list_member_id
1686: and p1.parent_member_id = p2.resource_list_member_id
1687: and p1.resource_list_member_id = x_uncat_res_list_member_id

Line 1684: pa_resource_list_members p2

1680: select distinct pbl1.resource_assignment_id
1681: from pa_budget_lines pbl1,
1682: pa_resource_assignments pra,
1683: pa_resource_list_members p1,
1684: pa_resource_list_members p2
1685: where pra.resource_list_member_id = p2.resource_list_member_id
1686: and p1.parent_member_id = p2.resource_list_member_id
1687: and p1.resource_list_member_id = x_uncat_res_list_member_id
1688: and pbl1.resource_assignment_id = pra.resource_assignment_id

Line 1863: pa_resource_list_members m

1859: l_resource_id,
1860: l_track_as_labor_flag
1861: from pa_periods p,
1862: pa_tasks t,
1863: pa_resource_list_members m
1864: where m.resource_list_id = x_resource_list_id
1865: and nvl(m.migration_code, 'M') = 'M'
1866: and not exists
1867: (select 1

Line 1868: from pa_resource_list_members m1

1864: where m.resource_list_id = x_resource_list_id
1865: and nvl(m.migration_code, 'M') = 'M'
1866: and not exists
1867: (select 1
1868: from pa_resource_list_members m1
1869: where m1.parent_member_id =
1870: m.resource_list_member_id)
1871: and t.project_id = x_project_id
1872: and t.task_id = t.top_task_id

Line 1924: FROM PA_RESOURCE_LIST_MEMBERS PRLM

1920: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
1921: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
1922: ( -- Fetch both 2nd level and group level resource list member
1923: SELECT PRLM.RESOURCE_LIST_MEMBER_ID
1924: FROM PA_RESOURCE_LIST_MEMBERS PRLM
1925: WHERE (prlm.resource_list_member_id = l_RESOURCE_LIST_MEMBER_ID(i)
1926: or
1927: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
1928: )

Line 1979: pa_resource_list_members m

1975: l_track_as_labor_flag
1976: from gl_period_statuses p,
1977: pa_implementations i,
1978: pa_tasks t,
1979: pa_resource_list_members m
1980: where m.resource_list_id = x_resource_list_id
1981: and not exists
1982: (select 1
1983: from pa_resource_list_members m1

Line 1983: from pa_resource_list_members m1

1979: pa_resource_list_members m
1980: where m.resource_list_id = x_resource_list_id
1981: and not exists
1982: (select 1
1983: from pa_resource_list_members m1
1984: where m1.parent_member_id =
1985: m.resource_list_member_id)
1986: and t.project_id = x_project_id
1987: and t.task_id = t.top_task_id

Line 2040: FROM PA_RESOURCE_LIST_MEMBERS PRLM

2036: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
2037: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
2038: ( -- Fetch both 2nd level and group level resource list member
2039: SELECT PRLM.RESOURCE_LIST_MEMBER_ID
2040: FROM PA_RESOURCE_LIST_MEMBERS PRLM
2041: WHERE (prlm.resource_list_member_id = l_RESOURCE_LIST_MEMBER_ID(i)
2042: or
2043: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
2044: )

Line 2135: pa_resource_list_members p1,

2131: where pbl.resource_assignment_id in (
2132: select distinct pbl1.resource_assignment_id
2133: from pa_budget_lines pbl1,
2134: pa_resource_assignments pra,
2135: pa_resource_list_members p1,
2136: pa_resource_list_members p2
2137: where pra.resource_list_member_id = p2.resource_list_member_id
2138: and p1.parent_member_id = p2.resource_list_member_id
2139: and p1.resource_list_member_id = TmpActTab(j).resource_list_member_id

Line 2136: pa_resource_list_members p2

2132: select distinct pbl1.resource_assignment_id
2133: from pa_budget_lines pbl1,
2134: pa_resource_assignments pra,
2135: pa_resource_list_members p1,
2136: pa_resource_list_members p2
2137: where pra.resource_list_member_id = p2.resource_list_member_id
2138: and p1.parent_member_id = p2.resource_list_member_id
2139: and p1.resource_list_member_id = TmpActTab(j).resource_list_member_id
2140: and pbl1.resource_assignment_id = pra.resource_assignment_id

Line 2461: from pa_resource_list_members m

2457: -- top level task, categorized
2458: for res_rec in (select m.resource_list_member_id,
2459: m.resource_id,
2460: m.track_as_labor_flag
2461: from pa_resource_list_members m
2462: where m.resource_list_id =
2463: x_resource_list_id
2464: and nvl(m.migration_code, 'M') = 'M'
2465: and not exists

Line 2467: from pa_resource_list_members m1

2463: x_resource_list_id
2464: and nvl(m.migration_code, 'M') = 'M'
2465: and not exists
2466: (select 1
2467: from pa_resource_list_members m1
2468: where m1.parent_member_id =
2469: m.resource_list_member_id)
2470: ) loop
2471:

Line 2874: pa_resource_list_members p1,

2870: where pbl.resource_assignment_id in (
2871: select distinct pbl1.resource_assignment_id
2872: from pa_budget_lines pbl1,
2873: pa_resource_assignments pra,
2874: pa_resource_list_members p1,
2875: pa_resource_list_members p2
2876: where pra.resource_list_member_id = p2.resource_list_member_id
2877: and p1.parent_member_id = p2.resource_list_member_id
2878: and p1.resource_list_member_id = x_uncat_res_list_member_id

Line 2875: pa_resource_list_members p2

2871: select distinct pbl1.resource_assignment_id
2872: from pa_budget_lines pbl1,
2873: pa_resource_assignments pra,
2874: pa_resource_list_members p1,
2875: pa_resource_list_members p2
2876: where pra.resource_list_member_id = p2.resource_list_member_id
2877: and p1.parent_member_id = p2.resource_list_member_id
2878: and p1.resource_list_member_id = x_uncat_res_list_member_id
2879: and pbl1.resource_assignment_id = pra.resource_assignment_id

Line 3055: pa_resource_list_members m

3051: l_resource_id,
3052: l_track_as_labor_flag
3053: from pa_periods p,
3054: pa_tasks t,
3055: pa_resource_list_members m
3056: where m.resource_list_id = x_resource_list_id
3057: and nvl(m.migration_code, 'M') = 'M'
3058: and not exists
3059: (select 1

Line 3060: from pa_resource_list_members m1

3056: where m.resource_list_id = x_resource_list_id
3057: and nvl(m.migration_code, 'M') = 'M'
3058: and not exists
3059: (select 1
3060: from pa_resource_list_members m1
3061: where m1.parent_member_id =
3062: m.resource_list_member_id)
3063: and t.project_id = x_project_id
3064: and not exists

Line 3119: FROM PA_RESOURCE_LIST_MEMBERS PRLM

3115: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
3116: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
3117: ( -- Fetch both 2nd level and group level resource list member
3118: SELECT PRLM.RESOURCE_LIST_MEMBER_ID
3119: FROM PA_RESOURCE_LIST_MEMBERS PRLM
3120: WHERE (prlm.resource_list_member_id = l_RESOURCE_LIST_MEMBER_ID(i)
3121: or
3122: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
3123: )

Line 3174: pa_resource_list_members m

3170: l_track_as_labor_flag
3171: from gl_period_statuses p,
3172: pa_implementations i,
3173: pa_tasks t,
3174: pa_resource_list_members m
3175: where m.resource_list_id = x_resource_list_id
3176: and not exists
3177: (select 1
3178: from pa_resource_list_members m1

Line 3178: from pa_resource_list_members m1

3174: pa_resource_list_members m
3175: where m.resource_list_id = x_resource_list_id
3176: and not exists
3177: (select 1
3178: from pa_resource_list_members m1
3179: where m1.parent_member_id =
3180: m.resource_list_member_id)
3181: and t.project_id = x_project_id
3182: and not exists

Line 3238: FROM PA_RESOURCE_LIST_MEMBERS PRLM

3234: WHERE PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
3235: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
3236: ( -- Fetch both 2nd level and group level resource list member
3237: SELECT PRLM.RESOURCE_LIST_MEMBER_ID
3238: FROM PA_RESOURCE_LIST_MEMBERS PRLM
3239: WHERE (prlm.resource_list_member_id = l_RESOURCE_LIST_MEMBER_ID(i)
3240: or
3241: PRLM.PARENT_MEMBER_ID = l_RESOURCE_LIST_MEMBER_ID(i) )
3242: )

Line 3333: pa_resource_list_members p1,

3329: where pbl.resource_assignment_id in (
3330: select distinct pbl1.resource_assignment_id
3331: from pa_budget_lines pbl1,
3332: pa_resource_assignments pra,
3333: pa_resource_list_members p1,
3334: pa_resource_list_members p2
3335: where pra.resource_list_member_id = p2.resource_list_member_id
3336: and p1.parent_member_id = p2.resource_list_member_id
3337: and p1.resource_list_member_id = TmpActTab(j).resource_list_member_id

Line 3334: pa_resource_list_members p2

3330: select distinct pbl1.resource_assignment_id
3331: from pa_budget_lines pbl1,
3332: pa_resource_assignments pra,
3333: pa_resource_list_members p1,
3334: pa_resource_list_members p2
3335: where pra.resource_list_member_id = p2.resource_list_member_id
3336: and p1.parent_member_id = p2.resource_list_member_id
3337: and p1.resource_list_member_id = TmpActTab(j).resource_list_member_id
3338: and pbl1.resource_assignment_id = pra.resource_assignment_id

Line 3656: from pa_resource_list_members m

3652: -- lowest level task, categorized
3653: for res_rec in (select m.resource_list_member_id,
3654: m.resource_id,
3655: m.track_as_labor_flag
3656: from pa_resource_list_members m
3657: where m.resource_list_id =
3658: x_resource_list_id
3659: and nvl(m.migration_code, 'M') = 'M'
3660: and not exists

Line 3662: from pa_resource_list_members m1

3658: x_resource_list_id
3659: and nvl(m.migration_code, 'M') = 'M'
3660: and not exists
3661: (select 1
3662: from pa_resource_list_members m1
3663: where m1.parent_member_id =
3664: m.resource_list_member_id)
3665: ) loop
3666:

Line 3867: from pa_resource_list_members p1,

3863: IS
3864: --BUG 6509313 Start
3865: cursor get_parent_member(x_child_member_id number) is
3866: select p2.resource_list_member_id parent_member_id
3867: from pa_resource_list_members p1,
3868: pa_resource_list_members p2
3869: where p1.parent_member_id = p2.resource_list_member_id
3870: and p1.resource_list_member_id = x_child_member_id; -- child id
3871:

Line 3868: pa_resource_list_members p2

3864: --BUG 6509313 Start
3865: cursor get_parent_member(x_child_member_id number) is
3866: select p2.resource_list_member_id parent_member_id
3867: from pa_resource_list_members p1,
3868: pa_resource_list_members p2
3869: where p1.parent_member_id = p2.resource_list_member_id
3870: and p1.resource_list_member_id = x_child_member_id; -- child id
3871:
3872: cursor parent_amounts(l_parent_id number,