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.PSP_TEMPLATE_SELECTION dependencies on PSP_ADJUSTMENT_LINES_HISTORY

Line 548: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

544: WHERE ppg.summary_line_id = psl.summary_line_id
545: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
546: AND ppg.adjustment_batch_name IS NULL AND
547: ppg.reversal_entry_flag IS NULL)
548: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
549: WHERE palh.summary_line_id = psl.summary_line_id
550: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
551: AND palh.adjustment_batch_name IS NULL
552: AND palh.reversal_entry_flag IS NULL AND

Line 587: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

583: WHERE ppg.summary_line_id = psl.summary_line_id
584: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
585: AND ppg.adjustment_batch_name IS NULL AND
586: ppg.reversal_entry_flag IS NULL)
587: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
588: WHERE palh.summary_line_id = psl.summary_line_id
589: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
590: AND palh.adjustment_batch_name IS NULL
591: AND palh.reversal_entry_flag IS NULL AND

Line 624: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

620: WHERE ppg.summary_line_id = psl.summary_line_id
621: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
622: AND ppg.adjustment_batch_name IS NULL AND
623: ppg.reversal_entry_flag IS NULL)
624: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
625: WHERE palh.summary_line_id = psl.summary_line_id
626: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
627: AND palh.adjustment_batch_name IS NULL
628: AND palh.reversal_entry_flag IS NULL AND

Line 660: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

656: WHERE ppg.summary_line_id = psl.summary_line_id
657: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
658: AND ppg.adjustment_batch_name IS NULL AND
659: ppg.reversal_entry_flag IS NULL)
660: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
661: WHERE palh.summary_line_id = psl.summary_line_id
662: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
663: AND palh.adjustment_batch_name IS NULL
664: AND palh.reversal_entry_flag IS NULL AND

Line 966: psp_adjustment_lines_history palh

962: if l_sql_string is not null then
963: g_exec_string := 'insert into psp_selection_cardinality_gt(lookup_code, total_count)
964: ( select '|| '''' || 'GLA' || ''''|| ' , count( distinct psl.person_id)
965: from psp_summary_lines psl, psp_distribution_lines_history pdnh, psp_pre_gen_dist_lines_history ppg,
966: psp_adjustment_lines_history palh
967: , gl_code_combinations gcc
968: where
969: psl.business_group_id = '|| p_business_group_id || ' and
970: psl.set_of_books_id =' || p_set_of_books_id || ' and

Line 1201: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

1197: WHERE ppg.summary_line_id = psl.summary_line_id
1198: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
1199: AND ppg.adjustment_batch_name IS NULL AND
1200: ppg.reversal_entry_flag IS NULL)
1201: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
1202: WHERE palh.summary_line_id = psl.summary_line_id
1203: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
1204: AND palh.adjustment_batch_name IS NULL
1205: AND palh.reversal_entry_flag IS NULL

Line 1244: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

1240: WHERE ppg.summary_line_id = psl.summary_line_id
1241: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
1242: AND ppg.adjustment_batch_name IS NULL AND
1243: ppg.reversal_entry_flag IS NULL)
1244: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
1245: WHERE palh.summary_line_id = psl.summary_line_id
1246: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
1247: AND palh.adjustment_batch_name IS NULL
1248: AND palh.reversal_entry_flag IS NULL AND

Line 1287: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

1283: WHERE ppg.summary_line_id = psl.summary_line_id
1284: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
1285: AND ppg.adjustment_batch_name IS NULL AND
1286: ppg.reversal_entry_flag IS NULL)
1287: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
1288: WHERE palh.summary_line_id = psl.summary_line_id
1289: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
1290: AND palh.adjustment_batch_name IS NULL
1291: AND palh.reversal_entry_flag IS NULL AND

Line 1334: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

1330: WHERE ppg.summary_line_id = psl.summary_line_id
1331: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
1332: AND ppg.adjustment_batch_name IS NULL AND
1333: ppg.reversal_entry_flag IS NULL)
1334: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
1335: WHERE palh.summary_line_id = psl.summary_line_id
1336: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
1337: AND palh.adjustment_batch_name IS NULL
1338: AND palh.reversal_entry_flag IS NULL AND

Line 1767: psp_adjustment_lines_history palh, psp_pre_gen_dist_lines_history ppg,

1763: if l_sql_string is not null then
1764: g_exec_string := 'insert into psp_selected_persons_t(request_id, person_id, assignment_id)
1765: ( select :p_request_id, psl.person_id, psl.assignment_id
1766: from psp_summary_lines psl, psp_distribution_lines_history pdnh,
1767: psp_adjustment_lines_history palh, psp_pre_gen_dist_lines_history ppg,
1768: gl_code_combinations gcc
1769: where
1770: psl.business_group_id = '|| p_business_group_id || ' and
1771: psl.set_of_books_id = ' || p_Set_of_books_id ||' and

Line 2063: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

2059: WHERE ppg.summary_line_id = psl.summary_line_id
2060: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
2061: AND ppg.adjustment_batch_name IS NULL AND
2062: ppg.reversal_entry_flag IS NULL)
2063: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
2064: WHERE palh.summary_line_id = psl.summary_line_id
2065: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
2066: AND palh.adjustment_batch_name IS NULL
2067: AND palh.reversal_entry_flag IS NULL

Line 2102: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

2098: WHERE ppg.summary_line_id = psl.summary_line_id
2099: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
2100: AND ppg.adjustment_batch_name IS NULL AND
2101: ppg.reversal_entry_flag IS NULL)
2102: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
2103: WHERE palh.summary_line_id = psl.summary_line_id
2104: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
2105: AND palh.adjustment_batch_name IS NULL
2106: AND palh.reversal_entry_flag IS NULL AND

Line 2140: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

2136: WHERE ppg.summary_line_id = psl.summary_line_id
2137: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
2138: AND ppg.adjustment_batch_name IS NULL AND
2139: ppg.reversal_entry_flag IS NULL)
2140: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
2141: WHERE palh.summary_line_id = psl.summary_line_id
2142: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
2143: AND palh.adjustment_batch_name IS NULL
2144: AND palh.reversal_entry_flag IS NULL AND

Line 2177: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

2173: WHERE ppg.summary_line_id = psl.summary_line_id
2174: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
2175: AND ppg.adjustment_batch_name IS NULL AND
2176: ppg.reversal_entry_flag IS NULL)
2177: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
2178: WHERE palh.summary_line_id = psl.summary_line_id
2179: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
2180: AND palh.adjustment_batch_name IS NULL
2181: AND palh.reversal_entry_flag IS NULL AND

Line 2613: psp_adjustment_lines_history palh, psp_pre_gen_dist_lines_history ppg,

2609:
2610: g_exec_string := 'delete from psp_selected_persons_t where person_id
2611: not in (select nvl(psl.person_id,0) from psp_summary_lines psl,
2612: psp_distribution_lines_history pdnh,
2613: psp_adjustment_lines_history palh, psp_pre_gen_dist_lines_history ppg,
2614: gl_code_combinations gcc
2615: where gcc.code_combination_id= psl.gl_code_combination_id and
2616: psl.business_group_id = '|| p_business_group_id || ' and
2617: psl.set_of_books_id = ' || p_set_of_books_id || ' and

Line 2846: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

2842: WHERE ppg.summary_line_id = psl.summary_line_id
2843: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
2844: AND ppg.adjustment_batch_name IS NULL AND
2845: ppg.reversal_entry_flag IS NULL)
2846: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
2847: WHERE palh.summary_line_id = psl.summary_line_id
2848: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
2849: AND palh.adjustment_batch_name IS NULL
2850: AND palh.reversal_entry_flag IS NULL

Line 2884: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

2880: WHERE ppg.summary_line_id = psl.summary_line_id
2881: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
2882: AND ppg.adjustment_batch_name IS NULL AND
2883: ppg.reversal_entry_flag IS NULL)
2884: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
2885: WHERE palh.summary_line_id = psl.summary_line_id
2886: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
2887: AND palh.adjustment_batch_name IS NULL
2888: AND palh.reversal_entry_flag IS NULL AND

Line 2922: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

2918: WHERE ppg.summary_line_id = psl.summary_line_id
2919: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
2920: AND ppg.adjustment_batch_name IS NULL AND
2921: ppg.reversal_entry_flag IS NULL)
2922: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
2923: WHERE palh.summary_line_id = psl.summary_line_id
2924: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
2925: AND palh.adjustment_batch_name IS NULL
2926: AND palh.reversal_entry_flag IS NULL AND

Line 2959: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

2955: WHERE ppg.summary_line_id = psl.summary_line_id
2956: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
2957: AND ppg.adjustment_batch_name IS NULL AND
2958: ppg.reversal_entry_flag IS NULL)
2959: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
2960: WHERE palh.summary_line_id = psl.summary_line_id
2961: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
2962: AND palh.adjustment_batch_name IS NULL
2963: AND palh.reversal_entry_flag IS NULL AND

Line 3374: psp_adjustment_lines_history palh, psp_pre_gen_dist_lines_history ppg,

3370:
3371: g_exec_string := 'delete from psp_selected_persons_t where person_id
3372: in (select nvl(psl.person_id,0) from psp_summary_lines psl,
3373: psp_distribution_lines_history pdnh,
3374: psp_adjustment_lines_history palh, psp_pre_gen_dist_lines_history ppg,
3375: gl_code_combinations gcc
3376: where gcc.code_combination_id= psl.gl_code_combination_id and
3377: psl.business_group_id = '|| p_business_group_id || ' and
3378: psl.set_of_books_id = ' || p_set_of_books_id || ' and

Line 3738: FROM psp_adjustment_lines_history palh

3734: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
3735: AND ppg.adjustment_batch_name IS NULL
3736: AND ppg.reversal_entry_flag IS NULL)
3737: OR EXISTS (SELECT 1
3738: FROM psp_adjustment_lines_history palh
3739: WHERE palh.summary_line_id = psl.summary_line_id
3740: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
3741: AND palh.adjustment_batch_name IS NULL
3742: AND palh.reversal_entry_flag IS NULL

Line 3777: FROM psp_adjustment_lines_history palh

3773: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
3774: AND ppg.adjustment_batch_name IS NULL
3775: AND ppg.reversal_entry_flag IS NULL)
3776: OR EXISTS (SELECT 1
3777: FROM psp_adjustment_lines_history palh
3778: WHERE palh.summary_line_id = psl.summary_line_id
3779: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
3780: AND palh.adjustment_batch_name IS NULL
3781: AND palh.reversal_entry_flag IS NULL

Line 3816: FROM psp_adjustment_lines_history palh

3812: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
3813: AND ppg.adjustment_batch_name IS NULL AND
3814: ppg.reversal_entry_flag IS NULL)
3815: OR EXISTS (SELECT 1
3816: FROM psp_adjustment_lines_history palh
3817: WHERE palh.summary_line_id = psl.summary_line_id
3818: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
3819: AND palh.adjustment_batch_name IS NULL
3820: AND palh.reversal_entry_flag IS NULL AND

Line 3851: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

3847: WHERE ppg.summary_line_id = psl.summary_line_id
3848: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
3849: AND ppg.adjustment_batch_name IS NULL
3850: AND ppg.reversal_entry_flag IS NULL)
3851: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
3852: WHERE palh.summary_line_id = psl.summary_line_id
3853: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
3854: AND palh.adjustment_batch_name IS NULL
3855: AND palh.reversal_entry_flag IS NULL

Line 4083: psp_adjustment_lines_history palh,

4079: SELECT '|| '''' || 'GLA' || ''''|| ' , COUNT( DISTINCT psl.assignment_id)
4080: FROM psp_summary_lines psl,
4081: psp_distribution_lines_history pdnh,
4082: psp_pre_gen_dist_lines_history ppg,
4083: psp_adjustment_lines_history palh,
4084: gl_code_combinations gcc
4085: WHERE psl.business_group_id = '|| p_business_group_id || '
4086: AND psl.set_of_books_id =' || p_set_of_books_id || '
4087: AND gcc.code_combination_id= psl.gl_code_combination_id

Line 4300: FROM psp_adjustment_lines_history palh

4296: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
4297: AND ppg.adjustment_batch_name IS NULL
4298: AND ppg.reversal_entry_flag IS NULL)
4299: OR EXISTS (SELECT 1
4300: FROM psp_adjustment_lines_history palh
4301: WHERE palh.summary_line_id = psl.summary_line_id
4302: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
4303: AND palh.adjustment_batch_name IS NULL
4304: AND palh.reversal_entry_flag IS NULL

Line 4337: FROM psp_adjustment_lines_history palh

4333: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
4334: AND ppg.adjustment_batch_name IS NULL
4335: AND ppg.reversal_entry_flag IS NULL)
4336: OR EXISTS (SELECT 1
4337: FROM psp_adjustment_lines_history palh
4338: WHERE palh.summary_line_id = psl.summary_line_id
4339: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
4340: AND palh.adjustment_batch_name IS NULL
4341: AND palh.reversal_entry_flag IS NULL

Line 4375: FROM psp_adjustment_lines_history palh

4371: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
4372: AND ppg.adjustment_batch_name IS NULL
4373: AND ppg.reversal_entry_flag IS NULL)
4374: OR EXISTS (SELECT 1
4375: FROM psp_adjustment_lines_history palh
4376: WHERE palh.summary_line_id = psl.summary_line_id
4377: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
4378: AND palh.adjustment_batch_name IS NULL
4379: AND palh.reversal_entry_flag IS NULL

Line 4411: FROM psp_adjustment_lines_history palh

4407: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
4408: AND ppg.adjustment_batch_name IS NULL
4409: AND ppg.reversal_entry_flag IS NULL)
4410: OR EXISTS (SELECT 1
4411: FROM psp_adjustment_lines_history palh
4412: WHERE palh.summary_line_id = psl.summary_line_id
4413: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
4414: AND palh.adjustment_batch_name IS NULL
4415: AND palh.reversal_entry_flag IS NULL

Line 4771: psp_adjustment_lines_history palh,

4767: g_exec_string := 'INSERT INTO psp_selected_persons_t(request_id, person_id, assignment_id)
4768: SELECT :p_request_id, psl.person_id, psl.assignment_id
4769: FROM psp_summary_lines psl,
4770: psp_distribution_lines_history pdnh,
4771: psp_adjustment_lines_history palh,
4772: psp_pre_gen_dist_lines_history ppg,
4773: gl_code_combinations gcc
4774: WHERE psl.business_group_id = '|| p_business_group_id || '
4775: AND psl.set_of_books_id = ' || p_set_of_books_id ||'

Line 4957: FROM psp_adjustment_lines_history palh

4953: AND p_effort_end
4954: AND ppg.adjustment_batch_name IS NULL
4955: AND ppg.reversal_entry_flag IS NULL)
4956: OR EXISTS (SELECT 1
4957: FROM psp_adjustment_lines_history palh
4958: WHERE palh.summary_line_id = psl.summary_line_id
4959: AND palh.distribution_date BETWEEN p_effort_start
4960: AND p_effort_end
4961: AND palh.adjustment_batch_name IS NULL

Line 4999: FROM psp_adjustment_lines_history palh

4995: AND p_effort_end
4996: AND ppg.adjustment_batch_name IS NULL
4997: AND ppg.reversal_entry_flag IS NULL)
4998: OR EXISTS (SELECT 1
4999: FROM psp_adjustment_lines_history palh
5000: WHERE palh.summary_line_id = psl.summary_line_id
5001: AND palh.distribution_date BETWEEN p_effort_start
5002: AND p_effort_end
5003: AND palh.adjustment_batch_name IS NULL

Line 5041: FROM psp_adjustment_lines_history palh

5037: AND p_effort_end
5038: AND ppg.adjustment_batch_name IS NULL
5039: AND ppg.reversal_entry_flag IS NULL)
5040: OR EXISTS (SELECT 1
5041: FROM psp_adjustment_lines_history palh
5042: WHERE palh.summary_line_id = psl.summary_line_id
5043: AND palh.distribution_date BETWEEN p_effort_start
5044: AND p_effort_end
5045: AND palh.adjustment_batch_name IS NULL

Line 5082: FROM psp_adjustment_lines_history palh

5078: AND p_effort_end
5079: AND ppg.adjustment_batch_name IS NULL
5080: AND ppg.reversal_entry_flag IS NULL)
5081: OR EXISTS (SELECT 1
5082: FROM psp_adjustment_lines_history palh
5083: WHERE palh.summary_line_id = psl.summary_line_id
5084: AND palh.distribution_date BETWEEN p_effort_start
5085: AND p_effort_end
5086: AND palh.adjustment_batch_name IS NULL

Line 5303: psp_adjustment_lines_history palh,

5299: IF l_sql_string IS NOT NULL THEN
5300: g_exec_string := 'DELETE FROM psp_selected_persons_t
5301: WHERE assignment_id NOT IN (SELECT NVL(psl.assignment_id,0)
5302: FROM psp_summary_lines psl, psp_distribution_lines_history pdnh,
5303: psp_adjustment_lines_history palh,
5304: psp_pre_gen_dist_lines_history ppg, gl_code_combinations gcc
5305: WHERE gcc.code_combination_id= psl.gl_code_combination_id
5306: AND psl.business_group_id = '|| p_business_group_id || '
5307: AND psl.set_of_books_id = ' || p_set_of_books_id || '

Line 5461: FROM psp_adjustment_lines_history palh

5457: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
5458: AND ppg.adjustment_batch_name IS NULL
5459: AND ppg.reversal_entry_flag IS NULL)
5460: OR EXISTS (SELECT 1
5461: FROM psp_adjustment_lines_history palh
5462: WHERE palh.summary_line_id = psl.summary_line_id
5463: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
5464: AND palh.adjustment_batch_name IS NULL
5465: AND palh.reversal_entry_flag IS NULL

Line 5500: FROM psp_adjustment_lines_history palh

5496: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
5497: AND ppg.adjustment_batch_name IS NULL
5498: AND ppg.reversal_entry_flag IS NULL)
5499: OR EXISTS (SELECT 1
5500: FROM psp_adjustment_lines_history palh
5501: WHERE palh.summary_line_id = psl.summary_line_id
5502: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
5503: AND palh.adjustment_batch_name IS NULL
5504: AND palh.reversal_entry_flag IS NULL

Line 5539: FROM psp_adjustment_lines_history palh

5535: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
5536: AND ppg.adjustment_batch_name IS NULL
5537: AND ppg.reversal_entry_flag IS NULL)
5538: OR EXISTS (SELECT 1
5539: FROM psp_adjustment_lines_history palh
5540: WHERE palh.summary_line_id = psl.summary_line_id
5541: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
5542: AND palh.adjustment_batch_name IS NULL
5543: AND palh.reversal_entry_flag IS NULL

Line 5577: FROM psp_adjustment_lines_history palh

5573: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
5574: AND ppg.adjustment_batch_name IS NULL
5575: AND ppg.reversal_entry_flag IS NULL)
5576: OR EXISTS (SELECT 1
5577: FROM psp_adjustment_lines_history palh
5578: WHERE palh.summary_line_id = psl.summary_line_id
5579: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
5580: AND palh.adjustment_batch_name IS NULL
5581: AND palh.reversal_entry_flag IS NULL

Line 5771: psp_adjustment_lines_history palh,

5767: g_exec_string := 'DELETE FROM psp_selected_persons_t
5768: WHERE assignment_id IN (SELECT NVL(psl.assignment_id,0)
5769: FROM psp_summary_lines psl,
5770: psp_distribution_lines_history pdnh,
5771: psp_adjustment_lines_history palh,
5772: psp_pre_gen_dist_lines_history ppg,
5773: gl_code_combinations gcc
5774: WHERE gcc.code_combination_id= psl.gl_code_combination_id
5775: AND psl.business_group_id = '|| p_business_group_id || '