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.

[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on PSP_SCHEDULE_LINES

Line 4224: psp_schedule_lines psl,

4220: SELECT GREATEST(l_min_start_date, peg.start_date_active, period_start_date) period_start_date,
4221: LEAST(l_max_end_date, peg.end_date_active, period_end_date) period_end_date,
4222: SUM(period_schedule_percent) schedule_percent
4223: FROM psp_matrix_driver pmd,
4224: psp_schedule_lines psl,
4225: psp_schedule_hierarchy psh,
4226: psp_element_groups peg
4227: WHERE run_id = l_run_id
4228: AND psl.schedule_line_id = pmd.schedule_line_id

Line 4257: FROM psp_schedule_lines

4253: SELECT schedule_line_id l_id,
4254: schedule_begin_date sbd,
4255: schedule_end_date sed,
4256: schedule_percent sp
4257: FROM psp_schedule_lines
4258: WHERE schedule_hierarchy_id = schedule_hierarchy_id
4259: AND ( gl_code_combination_id IS NOT NULL
4260: OR award_id IS NOT NULL)
4261: AND schedule_end_date >= l_min_start_date

Line 4266: FROM psp_schedule_lines

4262: AND schedule_begin_date <= l_max_end_date;
4263:
4264: CURSOR dates(p_schedule_hierarchy_id NUMBER) IS
4265: SELECT schedule_begin_date dat , 'B'
4266: FROM psp_schedule_lines
4267: WHERE schedule_hierarchy_id = p_schedule_hierarchy_id
4268: AND ( gl_code_combination_id IS NOT NULL
4269: OR award_id IS NOT NULL)
4270: AND schedule_end_date >= l_min_start_date

Line 4274: FROM psp_schedule_lines

4270: AND schedule_end_date >= l_min_start_date
4271: AND schedule_begin_date <= l_max_end_date
4272: UNION
4273: SELECT schedule_end_date dat , 'E'
4274: FROM psp_schedule_lines
4275: WHERE schedule_hierarchy_id = p_schedule_hierarchy_id
4276: AND ( gl_code_combination_id IS NOT NULL
4277: OR award_id IS NOT NULL)
4278: AND schedule_end_date >= l_min_start_date

Line 4617: FROM psp_schedule_lines psl1

4613: SET period_end_date = period_end_date - 1
4614: WHERE run_id = l_run_id
4615: AND period_start_date < period_end_date
4616: AND period_start_date = (SELECT MIN(psl1.schedule_begin_date)
4617: FROM psp_schedule_lines psl1
4618: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4619: AND EXISTS (SELECT 1
4620: FROM psp_schedule_lines psl1
4621: WHERE psl1.schedule_line_id <> pmd.schedule_line_id

Line 4620: FROM psp_schedule_lines psl1

4616: AND period_start_date = (SELECT MIN(psl1.schedule_begin_date)
4617: FROM psp_schedule_lines psl1
4618: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4619: AND EXISTS (SELECT 1
4620: FROM psp_schedule_lines psl1
4621: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
4622: AND psl1.schedule_begin_date = pmd.period_end_date
4623: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
4624:

Line 4630: FROM psp_schedule_lines psl1

4626: SET period_end_date = period_end_date - 1
4627: WHERE run_id = l_run_id
4628: AND period_start_date < period_end_date
4629: AND NOT (NOT EXISTS (SELECT 1
4630: FROM psp_schedule_lines psl1
4631: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
4632: AND psl1.schedule_begin_date = pmd.period_end_date
4633: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4634: AND EXISTS (SELECT 1

Line 4635: FROM psp_schedule_lines psl1

4631: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
4632: AND psl1.schedule_begin_date = pmd.period_end_date
4633: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4634: AND EXISTS (SELECT 1
4635: FROM psp_schedule_lines psl1
4636: WHERE psl1.schedule_end_date = pmd.period_end_date
4637: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id))
4638: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
4639: FROM psp_schedule_lines psl1

Line 4639: FROM psp_schedule_lines psl1

4635: FROM psp_schedule_lines psl1
4636: WHERE psl1.schedule_end_date = pmd.period_end_date
4637: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id))
4638: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
4639: FROM psp_schedule_lines psl1
4640: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
4641:
4642: UPDATE psp_matrix_driver pmd
4643: SET period_start_date = period_start_date + 1

Line 4647: FROM psp_schedule_lines psl1

4643: SET period_start_date = period_start_date + 1
4644: WHERE run_id = l_run_id
4645: AND period_start_date < period_end_date
4646: AND NOT EXISTS (SELECT 1
4647: FROM psp_schedule_lines psl1
4648: WHERE psl1.schedule_begin_date = pmd.period_start_date
4649: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4650: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
4651: FROM psp_schedule_lines psl1

Line 4651: FROM psp_schedule_lines psl1

4647: FROM psp_schedule_lines psl1
4648: WHERE psl1.schedule_begin_date = pmd.period_start_date
4649: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4650: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
4651: FROM psp_schedule_lines psl1
4652: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
4653:
4654: UPDATE psp_matrix_driver pmd
4655: SET period_start_date = period_start_date + 1

Line 4659: FROM psp_schedule_lines psl1

4655: SET period_start_date = period_start_date + 1
4656: WHERE run_id = l_run_id
4657: AND period_start_date < period_end_date
4658: AND EXISTS (SELECT 1
4659: FROM psp_schedule_lines psl1
4660: WHERE psl1.schedule_begin_date = pmd.period_start_date
4661: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4662: AND EXISTS (SELECT 1
4663: FROM psp_schedule_lines psl1

Line 4663: FROM psp_schedule_lines psl1

4659: FROM psp_schedule_lines psl1
4660: WHERE psl1.schedule_begin_date = pmd.period_start_date
4661: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4662: AND EXISTS (SELECT 1
4663: FROM psp_schedule_lines psl1
4664: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
4665: AND psl1.schedule_end_date = pmd.period_start_date
4666: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4667: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)

Line 4668: FROM psp_schedule_lines psl1

4664: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
4665: AND psl1.schedule_end_date = pmd.period_start_date
4666: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4667: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
4668: FROM psp_schedule_lines psl1
4669: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
4670: End of comment for bug fix 3970852 *****/
4671:
4672: -- Introduced the following to prepare schedule chunk dates instead of load_table for bug fix 3970852

Line 4710: FROM psp_schedule_lines psl

4706: SELECT l_run_id, schedule_line_id,
4707: GREATEST(l_min_start_date, schedule_chunk.schedule_begin_date(rowno)),
4708: LEAST(l_max_end_date, schedule_chunk.schedule_end_date(rowno)),
4709: schedule_percent
4710: FROM psp_schedule_lines psl
4711: WHERE schedule_hierarchy_id = l_schedule_hierarchy_id
4712: AND schedule_end_date >= l_min_start_date
4713: AND schedule_begin_date <= l_max_end_date
4714: AND ( gl_code_combination_id IS NOT NULL

Line 5016: FROM psp_schedule_lines psl1

5012: SET period_end_date = period_end_date - 1
5013: WHERE run_id = l_run_id
5014: AND period_start_date < period_end_date
5015: AND period_start_date = (SELECT MIN(psl1.schedule_begin_date)
5016: FROM psp_schedule_lines psl1
5017: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5018: AND EXISTS (SELECT 1
5019: FROM psp_schedule_lines psl1
5020: WHERE psl1.schedule_line_id <> pmd.schedule_line_id

Line 5019: FROM psp_schedule_lines psl1

5015: AND period_start_date = (SELECT MIN(psl1.schedule_begin_date)
5016: FROM psp_schedule_lines psl1
5017: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5018: AND EXISTS (SELECT 1
5019: FROM psp_schedule_lines psl1
5020: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
5021: AND psl1.schedule_begin_date = pmd.period_end_date
5022: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
5023:

Line 5029: FROM psp_schedule_lines psl1

5025: SET period_end_date = period_end_date - 1
5026: WHERE run_id = l_run_id
5027: AND period_start_date < period_end_date
5028: AND NOT (NOT EXISTS (SELECT 1
5029: FROM psp_schedule_lines psl1
5030: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
5031: AND psl1.schedule_begin_date = pmd.period_end_date
5032: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5033: AND EXISTS (SELECT 1

Line 5034: FROM psp_schedule_lines psl1

5030: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
5031: AND psl1.schedule_begin_date = pmd.period_end_date
5032: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5033: AND EXISTS (SELECT 1
5034: FROM psp_schedule_lines psl1
5035: WHERE psl1.schedule_end_date = pmd.period_end_date
5036: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id))
5037: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
5038: FROM psp_schedule_lines psl1

Line 5038: FROM psp_schedule_lines psl1

5034: FROM psp_schedule_lines psl1
5035: WHERE psl1.schedule_end_date = pmd.period_end_date
5036: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id))
5037: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
5038: FROM psp_schedule_lines psl1
5039: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
5040:
5041: UPDATE psp_matrix_driver pmd
5042: SET period_start_date = period_start_date + 1

Line 5046: FROM psp_schedule_lines psl1

5042: SET period_start_date = period_start_date + 1
5043: WHERE run_id = l_run_id
5044: AND period_start_date < period_end_date
5045: AND NOT EXISTS (SELECT 1
5046: FROM psp_schedule_lines psl1
5047: WHERE psl1.schedule_begin_date = pmd.period_start_date
5048: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5049: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
5050: FROM psp_schedule_lines psl1

Line 5050: FROM psp_schedule_lines psl1

5046: FROM psp_schedule_lines psl1
5047: WHERE psl1.schedule_begin_date = pmd.period_start_date
5048: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5049: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
5050: FROM psp_schedule_lines psl1
5051: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
5052:
5053: UPDATE psp_matrix_driver pmd
5054: SET period_start_date = period_start_date + 1

Line 5058: FROM psp_schedule_lines psl1

5054: SET period_start_date = period_start_date + 1
5055: WHERE run_id = l_run_id
5056: AND period_start_date < period_end_date
5057: AND EXISTS (SELECT 1
5058: FROM psp_schedule_lines psl1
5059: WHERE psl1.schedule_begin_date = pmd.period_start_date
5060: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5061: AND EXISTS (SELECT 1
5062: FROM psp_schedule_lines psl1

Line 5062: FROM psp_schedule_lines psl1

5058: FROM psp_schedule_lines psl1
5059: WHERE psl1.schedule_begin_date = pmd.period_start_date
5060: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5061: AND EXISTS (SELECT 1
5062: FROM psp_schedule_lines psl1
5063: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
5064: AND psl1.schedule_end_date = pmd.period_start_date
5065: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5066: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)

Line 5067: FROM psp_schedule_lines psl1

5063: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
5064: AND psl1.schedule_end_date = pmd.period_start_date
5065: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5066: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
5067: FROM psp_schedule_lines psl1
5068: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
5069: End of comment for bug fix 3970852 *****/
5070:
5071: -- Introduced the following to prepare schedule chunk dates instead of load_table for bug fix 3970852

Line 5109: FROM psp_schedule_lines psl

5105: SELECT l_run_id, schedule_line_id,
5106: GREATEST(l_min_start_date, schedule_chunk.schedule_begin_date(rowno)),
5107: LEAST(l_max_end_date, schedule_chunk.schedule_end_date(rowno)),
5108: schedule_percent
5109: FROM psp_schedule_lines psl
5110: WHERE schedule_hierarchy_id = l_schedule_hierarchy_id
5111: AND schedule_end_date >= l_min_start_date
5112: AND schedule_begin_date <= l_max_end_date
5113: AND ( gl_code_combination_id IS NOT NULL

Line 5415: FROM psp_schedule_lines psl1

5411: SET period_end_date = period_end_date - 1
5412: WHERE run_id = l_run_id
5413: AND period_start_date < period_end_date
5414: AND period_start_date = (SELECT MIN(psl1.schedule_begin_date)
5415: FROM psp_schedule_lines psl1
5416: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5417: AND EXISTS (SELECT 1
5418: FROM psp_schedule_lines psl1
5419: WHERE psl1.schedule_line_id <> pmd.schedule_line_id

Line 5418: FROM psp_schedule_lines psl1

5414: AND period_start_date = (SELECT MIN(psl1.schedule_begin_date)
5415: FROM psp_schedule_lines psl1
5416: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5417: AND EXISTS (SELECT 1
5418: FROM psp_schedule_lines psl1
5419: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
5420: AND psl1.schedule_begin_date = pmd.period_end_date
5421: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
5422:

Line 5428: FROM psp_schedule_lines psl1

5424: SET period_end_date = period_end_date - 1
5425: WHERE run_id = l_run_id
5426: AND period_start_date < period_end_date
5427: AND NOT (NOT EXISTS (SELECT 1
5428: FROM psp_schedule_lines psl1
5429: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
5430: AND psl1.schedule_begin_date = pmd.period_end_date
5431: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5432: AND EXISTS (SELECT 1

Line 5433: FROM psp_schedule_lines psl1

5429: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
5430: AND psl1.schedule_begin_date = pmd.period_end_date
5431: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5432: AND EXISTS (SELECT 1
5433: FROM psp_schedule_lines psl1
5434: WHERE psl1.schedule_end_date = pmd.period_end_date
5435: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id))
5436: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
5437: FROM psp_schedule_lines psl1

Line 5437: FROM psp_schedule_lines psl1

5433: FROM psp_schedule_lines psl1
5434: WHERE psl1.schedule_end_date = pmd.period_end_date
5435: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id))
5436: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
5437: FROM psp_schedule_lines psl1
5438: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
5439:
5440: UPDATE psp_matrix_driver pmd
5441: SET period_start_date = period_start_date + 1

Line 5445: FROM psp_schedule_lines psl1

5441: SET period_start_date = period_start_date + 1
5442: WHERE run_id = l_run_id
5443: AND period_start_date < period_end_date
5444: AND NOT EXISTS (SELECT 1
5445: FROM psp_schedule_lines psl1
5446: WHERE psl1.schedule_begin_date = pmd.period_start_date
5447: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5448: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
5449: FROM psp_schedule_lines psl1

Line 5449: FROM psp_schedule_lines psl1

5445: FROM psp_schedule_lines psl1
5446: WHERE psl1.schedule_begin_date = pmd.period_start_date
5447: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5448: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
5449: FROM psp_schedule_lines psl1
5450: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
5451:
5452: UPDATE psp_matrix_driver pmd
5453: SET period_start_date = period_start_date + 1

Line 5457: FROM psp_schedule_lines psl1

5453: SET period_start_date = period_start_date + 1
5454: WHERE run_id = l_run_id
5455: AND period_start_date < period_end_date
5456: AND EXISTS (SELECT 1
5457: FROM psp_schedule_lines psl1
5458: WHERE psl1.schedule_begin_date = pmd.period_start_date
5459: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5460: AND EXISTS (SELECT 1
5461: FROM psp_schedule_lines psl1

Line 5461: FROM psp_schedule_lines psl1

5457: FROM psp_schedule_lines psl1
5458: WHERE psl1.schedule_begin_date = pmd.period_start_date
5459: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5460: AND EXISTS (SELECT 1
5461: FROM psp_schedule_lines psl1
5462: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
5463: AND psl1.schedule_end_date = pmd.period_start_date
5464: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5465: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)

Line 5466: FROM psp_schedule_lines psl1

5462: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
5463: AND psl1.schedule_end_date = pmd.period_start_date
5464: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5465: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
5466: FROM psp_schedule_lines psl1
5467: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
5468: End of comment for bug fix 3970852 *****/
5469:
5470: -- Introduced the following to prepare schedule chunk dates instead of load_table for bug fix 3970852

Line 5507: FROM psp_schedule_lines psl

5503: SELECT l_run_id, schedule_line_id,
5504: GREATEST(l_min_start_date, schedule_chunk.schedule_begin_date(rowno)),
5505: LEAST(l_max_end_date, schedule_chunk.schedule_end_date(rowno)),
5506: schedule_percent
5507: FROM psp_schedule_lines psl
5508: WHERE schedule_hierarchy_id = l_schedule_hierarchy_id
5509: AND schedule_end_date >= l_min_start_date
5510: AND schedule_begin_date <= l_max_end_date
5511: AND ( gl_code_combination_id IS NOT NULL

Line 10396: psp_schedule_lines psl

10392: DECODE(g_dff_grouping_option, 'Y', psl.attribute9, NULL),
10393: DECODE(g_dff_grouping_option, 'Y', psl.attribute10, NULL),
10394: DECODE(psl.expenditure_type, NULL, 'N', 'E') acct_type
10395: FROM psp_schedule_hierarchy psh,
10396: psp_schedule_lines psl
10397: WHERE psh.assignment_id = p_assignment_id
10398: AND psh.element_type_id = p_element_type_id
10399: AND psh.business_group_id = p_business_group_id
10400: AND psh.set_of_books_id = p_set_of_books_id

Line 10437: psp_schedule_lines psl

10433: DECODE(psl.expenditure_type, NULL, 'N', 'E') acct_type
10434: FROM psp_element_types pet,
10435: psp_group_element_list pgel,
10436: psp_schedule_hierarchy psh,
10437: psp_schedule_lines psl
10438: WHERE pet.element_type_id = p_element_type_id
10439: AND pet.business_group_id = p_business_group_id
10440: AND pet.set_of_books_id = p_set_of_books_id
10441: AND pet.start_date_active <= g_enc_org_end_date

Line 10482: psp_schedule_lines psl

10478: DECODE(g_dff_grouping_option, 'Y', psl.attribute9, NULL),
10479: DECODE(g_dff_grouping_option, 'Y', psl.attribute10, NULL),
10480: DECODE(psl.expenditure_type, NULL, 'N', 'E') acct_type
10481: FROM psp_schedule_hierarchy psh,
10482: psp_schedule_lines psl
10483: WHERE psh.scheduling_types_code = 'A'
10484: AND psh.element_group_id IS NULL
10485: AND psh.element_type_id IS NULL
10486: AND psh.assignment_id = p_assignment_id