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 3988: psp_schedule_lines psl,

3984: SELECT GREATEST(l_min_start_date, peg.start_date_active, period_start_date) period_start_date,
3985: LEAST(l_max_end_date, peg.end_date_active, period_end_date) period_end_date,
3986: SUM(period_schedule_percent) schedule_percent
3987: FROM psp_matrix_driver pmd,
3988: psp_schedule_lines psl,
3989: psp_schedule_hierarchy psh,
3990: psp_element_groups peg
3991: WHERE run_id = l_run_id
3992: AND psl.schedule_line_id = pmd.schedule_line_id

Line 4021: FROM psp_schedule_lines

4017: SELECT schedule_line_id l_id,
4018: schedule_begin_date sbd,
4019: schedule_end_date sed,
4020: schedule_percent sp
4021: FROM psp_schedule_lines
4022: WHERE schedule_hierarchy_id = schedule_hierarchy_id
4023: AND ( gl_code_combination_id IS NOT NULL
4024: OR award_id IS NOT NULL)
4025: AND schedule_end_date >= l_min_start_date

Line 4030: FROM psp_schedule_lines

4026: AND schedule_begin_date <= l_max_end_date;
4027:
4028: CURSOR dates(p_schedule_hierarchy_id NUMBER) IS
4029: SELECT schedule_begin_date dat , 'B'
4030: FROM psp_schedule_lines
4031: WHERE schedule_hierarchy_id = p_schedule_hierarchy_id
4032: AND ( gl_code_combination_id IS NOT NULL
4033: OR award_id IS NOT NULL)
4034: AND schedule_end_date >= l_min_start_date

Line 4038: FROM psp_schedule_lines

4034: AND schedule_end_date >= l_min_start_date
4035: AND schedule_begin_date <= l_max_end_date
4036: UNION
4037: SELECT schedule_end_date dat , 'E'
4038: FROM psp_schedule_lines
4039: WHERE schedule_hierarchy_id = p_schedule_hierarchy_id
4040: AND ( gl_code_combination_id IS NOT NULL
4041: OR award_id IS NOT NULL)
4042: AND schedule_end_date >= l_min_start_date

Line 4381: FROM psp_schedule_lines psl1

4377: SET period_end_date = period_end_date - 1
4378: WHERE run_id = l_run_id
4379: AND period_start_date < period_end_date
4380: AND period_start_date = (SELECT MIN(psl1.schedule_begin_date)
4381: FROM psp_schedule_lines psl1
4382: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4383: AND EXISTS (SELECT 1
4384: FROM psp_schedule_lines psl1
4385: WHERE psl1.schedule_line_id <> pmd.schedule_line_id

Line 4384: FROM psp_schedule_lines psl1

4380: AND period_start_date = (SELECT MIN(psl1.schedule_begin_date)
4381: FROM psp_schedule_lines psl1
4382: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4383: AND EXISTS (SELECT 1
4384: FROM psp_schedule_lines psl1
4385: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
4386: AND psl1.schedule_begin_date = pmd.period_end_date
4387: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
4388:

Line 4394: FROM psp_schedule_lines psl1

4390: SET period_end_date = period_end_date - 1
4391: WHERE run_id = l_run_id
4392: AND period_start_date < period_end_date
4393: AND NOT (NOT EXISTS (SELECT 1
4394: FROM psp_schedule_lines psl1
4395: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
4396: AND psl1.schedule_begin_date = pmd.period_end_date
4397: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4398: AND EXISTS (SELECT 1

Line 4399: FROM psp_schedule_lines psl1

4395: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
4396: AND psl1.schedule_begin_date = pmd.period_end_date
4397: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4398: AND EXISTS (SELECT 1
4399: FROM psp_schedule_lines psl1
4400: WHERE psl1.schedule_end_date = pmd.period_end_date
4401: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id))
4402: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
4403: FROM psp_schedule_lines psl1

Line 4403: FROM psp_schedule_lines psl1

4399: FROM psp_schedule_lines psl1
4400: WHERE psl1.schedule_end_date = pmd.period_end_date
4401: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id))
4402: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
4403: FROM psp_schedule_lines psl1
4404: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
4405:
4406: UPDATE psp_matrix_driver pmd
4407: SET period_start_date = period_start_date + 1

Line 4411: FROM psp_schedule_lines psl1

4407: SET period_start_date = period_start_date + 1
4408: WHERE run_id = l_run_id
4409: AND period_start_date < period_end_date
4410: AND NOT EXISTS (SELECT 1
4411: FROM psp_schedule_lines psl1
4412: WHERE psl1.schedule_begin_date = pmd.period_start_date
4413: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4414: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
4415: FROM psp_schedule_lines psl1

Line 4415: FROM psp_schedule_lines psl1

4411: FROM psp_schedule_lines psl1
4412: WHERE psl1.schedule_begin_date = pmd.period_start_date
4413: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4414: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
4415: FROM psp_schedule_lines psl1
4416: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
4417:
4418: UPDATE psp_matrix_driver pmd
4419: SET period_start_date = period_start_date + 1

Line 4423: FROM psp_schedule_lines psl1

4419: SET period_start_date = period_start_date + 1
4420: WHERE run_id = l_run_id
4421: AND period_start_date < period_end_date
4422: AND EXISTS (SELECT 1
4423: FROM psp_schedule_lines psl1
4424: WHERE psl1.schedule_begin_date = pmd.period_start_date
4425: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4426: AND EXISTS (SELECT 1
4427: FROM psp_schedule_lines psl1

Line 4427: FROM psp_schedule_lines psl1

4423: FROM psp_schedule_lines psl1
4424: WHERE psl1.schedule_begin_date = pmd.period_start_date
4425: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4426: AND EXISTS (SELECT 1
4427: FROM psp_schedule_lines psl1
4428: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
4429: AND psl1.schedule_end_date = pmd.period_start_date
4430: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4431: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)

Line 4432: FROM psp_schedule_lines psl1

4428: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
4429: AND psl1.schedule_end_date = pmd.period_start_date
4430: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4431: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
4432: FROM psp_schedule_lines psl1
4433: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
4434: End of comment for bug fix 3970852 *****/
4435:
4436: -- Introduced the following to prepare schedule chunk dates instead of load_table for bug fix 3970852

Line 4474: FROM psp_schedule_lines psl

4470: SELECT l_run_id, schedule_line_id,
4471: GREATEST(l_min_start_date, schedule_chunk.schedule_begin_date(rowno)),
4472: LEAST(l_max_end_date, schedule_chunk.schedule_end_date(rowno)),
4473: schedule_percent
4474: FROM psp_schedule_lines psl
4475: WHERE schedule_hierarchy_id = l_schedule_hierarchy_id
4476: AND schedule_end_date >= l_min_start_date
4477: AND schedule_begin_date <= l_max_end_date
4478: AND ( gl_code_combination_id IS NOT NULL

Line 4780: FROM psp_schedule_lines psl1

4776: SET period_end_date = period_end_date - 1
4777: WHERE run_id = l_run_id
4778: AND period_start_date < period_end_date
4779: AND period_start_date = (SELECT MIN(psl1.schedule_begin_date)
4780: FROM psp_schedule_lines psl1
4781: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4782: AND EXISTS (SELECT 1
4783: FROM psp_schedule_lines psl1
4784: WHERE psl1.schedule_line_id <> pmd.schedule_line_id

Line 4783: FROM psp_schedule_lines psl1

4779: AND period_start_date = (SELECT MIN(psl1.schedule_begin_date)
4780: FROM psp_schedule_lines psl1
4781: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4782: AND EXISTS (SELECT 1
4783: FROM psp_schedule_lines psl1
4784: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
4785: AND psl1.schedule_begin_date = pmd.period_end_date
4786: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
4787:

Line 4793: FROM psp_schedule_lines psl1

4789: SET period_end_date = period_end_date - 1
4790: WHERE run_id = l_run_id
4791: AND period_start_date < period_end_date
4792: AND NOT (NOT EXISTS (SELECT 1
4793: FROM psp_schedule_lines psl1
4794: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
4795: AND psl1.schedule_begin_date = pmd.period_end_date
4796: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4797: AND EXISTS (SELECT 1

Line 4798: FROM psp_schedule_lines psl1

4794: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
4795: AND psl1.schedule_begin_date = pmd.period_end_date
4796: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4797: AND EXISTS (SELECT 1
4798: FROM psp_schedule_lines psl1
4799: WHERE psl1.schedule_end_date = pmd.period_end_date
4800: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id))
4801: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
4802: FROM psp_schedule_lines psl1

Line 4802: FROM psp_schedule_lines psl1

4798: FROM psp_schedule_lines psl1
4799: WHERE psl1.schedule_end_date = pmd.period_end_date
4800: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id))
4801: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
4802: FROM psp_schedule_lines psl1
4803: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
4804:
4805: UPDATE psp_matrix_driver pmd
4806: SET period_start_date = period_start_date + 1

Line 4810: FROM psp_schedule_lines psl1

4806: SET period_start_date = period_start_date + 1
4807: WHERE run_id = l_run_id
4808: AND period_start_date < period_end_date
4809: AND NOT EXISTS (SELECT 1
4810: FROM psp_schedule_lines psl1
4811: WHERE psl1.schedule_begin_date = pmd.period_start_date
4812: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4813: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
4814: FROM psp_schedule_lines psl1

Line 4814: FROM psp_schedule_lines psl1

4810: FROM psp_schedule_lines psl1
4811: WHERE psl1.schedule_begin_date = pmd.period_start_date
4812: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4813: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
4814: FROM psp_schedule_lines psl1
4815: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
4816:
4817: UPDATE psp_matrix_driver pmd
4818: SET period_start_date = period_start_date + 1

Line 4822: FROM psp_schedule_lines psl1

4818: SET period_start_date = period_start_date + 1
4819: WHERE run_id = l_run_id
4820: AND period_start_date < period_end_date
4821: AND EXISTS (SELECT 1
4822: FROM psp_schedule_lines psl1
4823: WHERE psl1.schedule_begin_date = pmd.period_start_date
4824: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4825: AND EXISTS (SELECT 1
4826: FROM psp_schedule_lines psl1

Line 4826: FROM psp_schedule_lines psl1

4822: FROM psp_schedule_lines psl1
4823: WHERE psl1.schedule_begin_date = pmd.period_start_date
4824: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4825: AND EXISTS (SELECT 1
4826: FROM psp_schedule_lines psl1
4827: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
4828: AND psl1.schedule_end_date = pmd.period_start_date
4829: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4830: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)

Line 4831: FROM psp_schedule_lines psl1

4827: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
4828: AND psl1.schedule_end_date = pmd.period_start_date
4829: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
4830: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
4831: FROM psp_schedule_lines psl1
4832: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
4833: End of comment for bug fix 3970852 *****/
4834:
4835: -- Introduced the following to prepare schedule chunk dates instead of load_table for bug fix 3970852

Line 4873: FROM psp_schedule_lines psl

4869: SELECT l_run_id, schedule_line_id,
4870: GREATEST(l_min_start_date, schedule_chunk.schedule_begin_date(rowno)),
4871: LEAST(l_max_end_date, schedule_chunk.schedule_end_date(rowno)),
4872: schedule_percent
4873: FROM psp_schedule_lines psl
4874: WHERE schedule_hierarchy_id = l_schedule_hierarchy_id
4875: AND schedule_end_date >= l_min_start_date
4876: AND schedule_begin_date <= l_max_end_date
4877: AND ( gl_code_combination_id IS NOT NULL

Line 5179: FROM psp_schedule_lines psl1

5175: SET period_end_date = period_end_date - 1
5176: WHERE run_id = l_run_id
5177: AND period_start_date < period_end_date
5178: AND period_start_date = (SELECT MIN(psl1.schedule_begin_date)
5179: FROM psp_schedule_lines psl1
5180: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5181: AND EXISTS (SELECT 1
5182: FROM psp_schedule_lines psl1
5183: WHERE psl1.schedule_line_id <> pmd.schedule_line_id

Line 5182: FROM psp_schedule_lines psl1

5178: AND period_start_date = (SELECT MIN(psl1.schedule_begin_date)
5179: FROM psp_schedule_lines psl1
5180: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5181: AND EXISTS (SELECT 1
5182: FROM psp_schedule_lines psl1
5183: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
5184: AND psl1.schedule_begin_date = pmd.period_end_date
5185: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
5186:

Line 5192: FROM psp_schedule_lines psl1

5188: SET period_end_date = period_end_date - 1
5189: WHERE run_id = l_run_id
5190: AND period_start_date < period_end_date
5191: AND NOT (NOT EXISTS (SELECT 1
5192: FROM psp_schedule_lines psl1
5193: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
5194: AND psl1.schedule_begin_date = pmd.period_end_date
5195: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5196: AND EXISTS (SELECT 1

Line 5197: FROM psp_schedule_lines psl1

5193: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
5194: AND psl1.schedule_begin_date = pmd.period_end_date
5195: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5196: AND EXISTS (SELECT 1
5197: FROM psp_schedule_lines psl1
5198: WHERE psl1.schedule_end_date = pmd.period_end_date
5199: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id))
5200: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
5201: FROM psp_schedule_lines psl1

Line 5201: FROM psp_schedule_lines psl1

5197: FROM psp_schedule_lines psl1
5198: WHERE psl1.schedule_end_date = pmd.period_end_date
5199: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id))
5200: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
5201: FROM psp_schedule_lines psl1
5202: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
5203:
5204: UPDATE psp_matrix_driver pmd
5205: SET period_start_date = period_start_date + 1

Line 5209: FROM psp_schedule_lines psl1

5205: SET period_start_date = period_start_date + 1
5206: WHERE run_id = l_run_id
5207: AND period_start_date < period_end_date
5208: AND NOT EXISTS (SELECT 1
5209: FROM psp_schedule_lines psl1
5210: WHERE psl1.schedule_begin_date = pmd.period_start_date
5211: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5212: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
5213: FROM psp_schedule_lines psl1

Line 5213: FROM psp_schedule_lines psl1

5209: FROM psp_schedule_lines psl1
5210: WHERE psl1.schedule_begin_date = pmd.period_start_date
5211: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5212: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
5213: FROM psp_schedule_lines psl1
5214: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
5215:
5216: UPDATE psp_matrix_driver pmd
5217: SET period_start_date = period_start_date + 1

Line 5221: FROM psp_schedule_lines psl1

5217: SET period_start_date = period_start_date + 1
5218: WHERE run_id = l_run_id
5219: AND period_start_date < period_end_date
5220: AND EXISTS (SELECT 1
5221: FROM psp_schedule_lines psl1
5222: WHERE psl1.schedule_begin_date = pmd.period_start_date
5223: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5224: AND EXISTS (SELECT 1
5225: FROM psp_schedule_lines psl1

Line 5225: FROM psp_schedule_lines psl1

5221: FROM psp_schedule_lines psl1
5222: WHERE psl1.schedule_begin_date = pmd.period_start_date
5223: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5224: AND EXISTS (SELECT 1
5225: FROM psp_schedule_lines psl1
5226: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
5227: AND psl1.schedule_end_date = pmd.period_start_date
5228: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5229: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)

Line 5230: FROM psp_schedule_lines psl1

5226: WHERE psl1.schedule_line_id <> pmd.schedule_line_id
5227: AND psl1.schedule_end_date = pmd.period_start_date
5228: AND psl1.schedule_hierarchy_id = l_schedule_hierarchy_id)
5229: AND period_start_date <> (SELECT MIN(psl1.schedule_begin_date)
5230: FROM psp_schedule_lines psl1
5231: WHERE psl1.schedule_hierarchy_id = l_schedule_hierarchy_id);
5232: End of comment for bug fix 3970852 *****/
5233:
5234: -- Introduced the following to prepare schedule chunk dates instead of load_table for bug fix 3970852

Line 5271: FROM psp_schedule_lines psl

5267: SELECT l_run_id, schedule_line_id,
5268: GREATEST(l_min_start_date, schedule_chunk.schedule_begin_date(rowno)),
5269: LEAST(l_max_end_date, schedule_chunk.schedule_end_date(rowno)),
5270: schedule_percent
5271: FROM psp_schedule_lines psl
5272: WHERE schedule_hierarchy_id = l_schedule_hierarchy_id
5273: AND schedule_end_date >= l_min_start_date
5274: AND schedule_begin_date <= l_max_end_date
5275: AND ( gl_code_combination_id IS NOT NULL

Line 9766: psp_schedule_lines psl

9762: DECODE(g_dff_grouping_option, 'Y', psl.attribute9, NULL),
9763: DECODE(g_dff_grouping_option, 'Y', psl.attribute10, NULL),
9764: DECODE(psl.expenditure_type, NULL, 'N', 'E') acct_type
9765: FROM psp_schedule_hierarchy psh,
9766: psp_schedule_lines psl
9767: WHERE psh.assignment_id = p_assignment_id
9768: AND psh.element_type_id = p_element_type_id
9769: AND psh.business_group_id = p_business_group_id
9770: AND psh.set_of_books_id = p_set_of_books_id

Line 9807: psp_schedule_lines psl

9803: DECODE(psl.expenditure_type, NULL, 'N', 'E') acct_type
9804: FROM psp_element_types pet,
9805: psp_group_element_list pgel,
9806: psp_schedule_hierarchy psh,
9807: psp_schedule_lines psl
9808: WHERE pet.element_type_id = p_element_type_id
9809: AND pet.business_group_id = p_business_group_id
9810: AND pet.set_of_books_id = p_set_of_books_id
9811: AND pet.start_date_active <= g_enc_org_end_date

Line 9852: psp_schedule_lines psl

9848: DECODE(g_dff_grouping_option, 'Y', psl.attribute9, NULL),
9849: DECODE(g_dff_grouping_option, 'Y', psl.attribute10, NULL),
9850: DECODE(psl.expenditure_type, NULL, 'N', 'E') acct_type
9851: FROM psp_schedule_hierarchy psh,
9852: psp_schedule_lines psl
9853: WHERE psh.scheduling_types_code = 'A'
9854: AND psh.element_group_id IS NULL
9855: AND psh.element_type_id IS NULL
9856: AND psh.assignment_id = p_assignment_id