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_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 2030: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

2026: WHERE ppg.summary_line_id = psl.summary_line_id
2027: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
2028: AND ppg.adjustment_batch_name IS NULL AND
2029: ppg.reversal_entry_flag IS NULL)
2030: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
2031: WHERE palh.summary_line_id = psl.summary_line_id
2032: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
2033: AND palh.adjustment_batch_name IS NULL
2034: AND palh.reversal_entry_flag IS NULL

Line 2069: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

2065: WHERE ppg.summary_line_id = psl.summary_line_id
2066: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
2067: AND ppg.adjustment_batch_name IS NULL AND
2068: ppg.reversal_entry_flag IS NULL)
2069: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
2070: WHERE palh.summary_line_id = psl.summary_line_id
2071: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
2072: AND palh.adjustment_batch_name IS NULL
2073: AND palh.reversal_entry_flag IS NULL AND

Line 2107: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

2103: WHERE ppg.summary_line_id = psl.summary_line_id
2104: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
2105: AND ppg.adjustment_batch_name IS NULL AND
2106: ppg.reversal_entry_flag IS NULL)
2107: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
2108: WHERE palh.summary_line_id = psl.summary_line_id
2109: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
2110: AND palh.adjustment_batch_name IS NULL
2111: AND palh.reversal_entry_flag IS NULL AND

Line 2144: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

2140: WHERE ppg.summary_line_id = psl.summary_line_id
2141: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
2142: AND ppg.adjustment_batch_name IS NULL AND
2143: ppg.reversal_entry_flag IS NULL)
2144: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
2145: WHERE palh.summary_line_id = psl.summary_line_id
2146: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
2147: AND palh.adjustment_batch_name IS NULL
2148: AND palh.reversal_entry_flag IS NULL AND

Line 2580: psp_adjustment_lines_history palh, psp_pre_gen_dist_lines_history ppg,

2576:
2577: g_exec_string := 'delete from psp_selected_persons_t where person_id
2578: not in (select nvl(psl.person_id,0) from psp_summary_lines psl,
2579: psp_distribution_lines_history pdnh,
2580: psp_adjustment_lines_history palh, psp_pre_gen_dist_lines_history ppg,
2581: gl_code_combinations gcc
2582: where gcc.code_combination_id= psl.gl_code_combination_id and
2583: psl.business_group_id = '|| p_business_group_id || ' and
2584: psl.set_of_books_id = ' || p_set_of_books_id || ' and

Line 2813: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

2809: WHERE ppg.summary_line_id = psl.summary_line_id
2810: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
2811: AND ppg.adjustment_batch_name IS NULL AND
2812: ppg.reversal_entry_flag IS NULL)
2813: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
2814: WHERE palh.summary_line_id = psl.summary_line_id
2815: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
2816: AND palh.adjustment_batch_name IS NULL
2817: AND palh.reversal_entry_flag IS NULL

Line 2851: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

2847: WHERE ppg.summary_line_id = psl.summary_line_id
2848: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
2849: AND ppg.adjustment_batch_name IS NULL AND
2850: ppg.reversal_entry_flag IS NULL)
2851: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
2852: WHERE palh.summary_line_id = psl.summary_line_id
2853: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
2854: AND palh.adjustment_batch_name IS NULL
2855: AND palh.reversal_entry_flag IS NULL AND

Line 2889: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

2885: WHERE ppg.summary_line_id = psl.summary_line_id
2886: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
2887: AND ppg.adjustment_batch_name IS NULL AND
2888: ppg.reversal_entry_flag IS NULL)
2889: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
2890: WHERE palh.summary_line_id = psl.summary_line_id
2891: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
2892: AND palh.adjustment_batch_name IS NULL
2893: AND palh.reversal_entry_flag IS NULL AND

Line 2926: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

2922: WHERE ppg.summary_line_id = psl.summary_line_id
2923: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
2924: AND ppg.adjustment_batch_name IS NULL AND
2925: ppg.reversal_entry_flag IS NULL)
2926: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh
2927: WHERE palh.summary_line_id = psl.summary_line_id
2928: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
2929: AND palh.adjustment_batch_name IS NULL
2930: AND palh.reversal_entry_flag IS NULL AND

Line 3341: psp_adjustment_lines_history palh, psp_pre_gen_dist_lines_history ppg,

3337:
3338: g_exec_string := 'delete from psp_selected_persons_t where person_id
3339: in (select nvl(psl.person_id,0) from psp_summary_lines psl,
3340: psp_distribution_lines_history pdnh,
3341: psp_adjustment_lines_history palh, psp_pre_gen_dist_lines_history ppg,
3342: gl_code_combinations gcc
3343: where gcc.code_combination_id= psl.gl_code_combination_id and
3344: psl.business_group_id = '|| p_business_group_id || ' and
3345: psl.set_of_books_id = ' || p_set_of_books_id || ' and

Line 3705: FROM psp_adjustment_lines_history palh

3701: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
3702: AND ppg.adjustment_batch_name IS NULL
3703: AND ppg.reversal_entry_flag IS NULL)
3704: OR EXISTS (SELECT 1
3705: FROM psp_adjustment_lines_history palh
3706: WHERE palh.summary_line_id = psl.summary_line_id
3707: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
3708: AND palh.adjustment_batch_name IS NULL
3709: AND palh.reversal_entry_flag IS NULL

Line 3744: FROM psp_adjustment_lines_history palh

3740: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
3741: AND ppg.adjustment_batch_name IS NULL
3742: AND ppg.reversal_entry_flag IS NULL)
3743: OR EXISTS (SELECT 1
3744: FROM psp_adjustment_lines_history palh
3745: WHERE palh.summary_line_id = psl.summary_line_id
3746: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
3747: AND palh.adjustment_batch_name IS NULL
3748: AND palh.reversal_entry_flag IS NULL

Line 3783: FROM psp_adjustment_lines_history palh

3779: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
3780: AND ppg.adjustment_batch_name IS NULL AND
3781: ppg.reversal_entry_flag IS NULL)
3782: OR EXISTS (SELECT 1
3783: FROM psp_adjustment_lines_history palh
3784: WHERE palh.summary_line_id = psl.summary_line_id
3785: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
3786: AND palh.adjustment_batch_name IS NULL
3787: AND palh.reversal_entry_flag IS NULL AND

Line 3818: OR EXISTS (SELECT 1 FROM psp_adjustment_lines_history palh

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

Line 4050: psp_adjustment_lines_history palh,

4046: SELECT '|| '''' || 'GLA' || ''''|| ' , COUNT( DISTINCT psl.assignment_id)
4047: FROM psp_summary_lines psl,
4048: psp_distribution_lines_history pdnh,
4049: psp_pre_gen_dist_lines_history ppg,
4050: psp_adjustment_lines_history palh,
4051: gl_code_combinations gcc
4052: WHERE psl.business_group_id = '|| p_business_group_id || '
4053: AND psl.set_of_books_id =' || p_set_of_books_id || '
4054: AND gcc.code_combination_id= psl.gl_code_combination_id

Line 4267: FROM psp_adjustment_lines_history palh

4263: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
4264: AND ppg.adjustment_batch_name IS NULL
4265: AND ppg.reversal_entry_flag IS NULL)
4266: OR EXISTS (SELECT 1
4267: FROM psp_adjustment_lines_history palh
4268: WHERE palh.summary_line_id = psl.summary_line_id
4269: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
4270: AND palh.adjustment_batch_name IS NULL
4271: AND palh.reversal_entry_flag IS NULL

Line 4304: FROM psp_adjustment_lines_history palh

4300: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
4301: AND ppg.adjustment_batch_name IS NULL
4302: AND ppg.reversal_entry_flag IS NULL)
4303: OR EXISTS (SELECT 1
4304: FROM psp_adjustment_lines_history palh
4305: WHERE palh.summary_line_id = psl.summary_line_id
4306: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
4307: AND palh.adjustment_batch_name IS NULL
4308: AND palh.reversal_entry_flag IS NULL

Line 4342: FROM psp_adjustment_lines_history palh

4338: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
4339: AND ppg.adjustment_batch_name IS NULL
4340: AND ppg.reversal_entry_flag IS NULL)
4341: OR EXISTS (SELECT 1
4342: FROM psp_adjustment_lines_history palh
4343: WHERE palh.summary_line_id = psl.summary_line_id
4344: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
4345: AND palh.adjustment_batch_name IS NULL
4346: AND palh.reversal_entry_flag IS NULL

Line 4378: FROM psp_adjustment_lines_history palh

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

Line 4738: psp_adjustment_lines_history palh,

4734: g_exec_string := 'INSERT INTO psp_selected_persons_t(request_id, person_id, assignment_id)
4735: SELECT :p_request_id, psl.person_id, psl.assignment_id
4736: FROM psp_summary_lines psl,
4737: psp_distribution_lines_history pdnh,
4738: psp_adjustment_lines_history palh,
4739: psp_pre_gen_dist_lines_history ppg,
4740: gl_code_combinations gcc
4741: WHERE psl.business_group_id = '|| p_business_group_id || '
4742: AND psl.set_of_books_id = ' || p_set_of_books_id ||'

Line 4924: FROM psp_adjustment_lines_history palh

4920: AND p_effort_end
4921: AND ppg.adjustment_batch_name IS NULL
4922: AND ppg.reversal_entry_flag IS NULL)
4923: OR EXISTS (SELECT 1
4924: FROM psp_adjustment_lines_history palh
4925: WHERE palh.summary_line_id = psl.summary_line_id
4926: AND palh.distribution_date BETWEEN p_effort_start
4927: AND p_effort_end
4928: AND palh.adjustment_batch_name IS NULL

Line 4966: FROM psp_adjustment_lines_history palh

4962: AND p_effort_end
4963: AND ppg.adjustment_batch_name IS NULL
4964: AND ppg.reversal_entry_flag IS NULL)
4965: OR EXISTS (SELECT 1
4966: FROM psp_adjustment_lines_history palh
4967: WHERE palh.summary_line_id = psl.summary_line_id
4968: AND palh.distribution_date BETWEEN p_effort_start
4969: AND p_effort_end
4970: AND palh.adjustment_batch_name IS NULL

Line 5008: FROM psp_adjustment_lines_history palh

5004: AND p_effort_end
5005: AND ppg.adjustment_batch_name IS NULL
5006: AND ppg.reversal_entry_flag IS NULL)
5007: OR EXISTS (SELECT 1
5008: FROM psp_adjustment_lines_history palh
5009: WHERE palh.summary_line_id = psl.summary_line_id
5010: AND palh.distribution_date BETWEEN p_effort_start
5011: AND p_effort_end
5012: AND palh.adjustment_batch_name IS NULL

Line 5049: FROM psp_adjustment_lines_history palh

5045: AND p_effort_end
5046: AND ppg.adjustment_batch_name IS NULL
5047: AND ppg.reversal_entry_flag IS NULL)
5048: OR EXISTS (SELECT 1
5049: FROM psp_adjustment_lines_history palh
5050: WHERE palh.summary_line_id = psl.summary_line_id
5051: AND palh.distribution_date BETWEEN p_effort_start
5052: AND p_effort_end
5053: AND palh.adjustment_batch_name IS NULL

Line 5270: psp_adjustment_lines_history palh,

5266: IF l_sql_string IS NOT NULL THEN
5267: g_exec_string := 'DELETE FROM psp_selected_persons_t
5268: WHERE assignment_id NOT IN (SELECT NVL(psl.assignment_id,0)
5269: FROM psp_summary_lines psl, psp_distribution_lines_history pdnh,
5270: psp_adjustment_lines_history palh,
5271: psp_pre_gen_dist_lines_history ppg, gl_code_combinations gcc
5272: WHERE gcc.code_combination_id= psl.gl_code_combination_id
5273: AND psl.business_group_id = '|| p_business_group_id || '
5274: AND psl.set_of_books_id = ' || p_set_of_books_id || '

Line 5428: FROM psp_adjustment_lines_history palh

5424: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
5425: AND ppg.adjustment_batch_name IS NULL
5426: AND ppg.reversal_entry_flag IS NULL)
5427: OR EXISTS (SELECT 1
5428: FROM psp_adjustment_lines_history palh
5429: WHERE palh.summary_line_id = psl.summary_line_id
5430: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
5431: AND palh.adjustment_batch_name IS NULL
5432: AND palh.reversal_entry_flag IS NULL

Line 5467: FROM psp_adjustment_lines_history palh

5463: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
5464: AND ppg.adjustment_batch_name IS NULL
5465: AND ppg.reversal_entry_flag IS NULL)
5466: OR EXISTS (SELECT 1
5467: FROM psp_adjustment_lines_history palh
5468: WHERE palh.summary_line_id = psl.summary_line_id
5469: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
5470: AND palh.adjustment_batch_name IS NULL
5471: AND palh.reversal_entry_flag IS NULL

Line 5506: FROM psp_adjustment_lines_history palh

5502: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
5503: AND ppg.adjustment_batch_name IS NULL
5504: AND ppg.reversal_entry_flag IS NULL)
5505: OR EXISTS (SELECT 1
5506: FROM psp_adjustment_lines_history palh
5507: WHERE palh.summary_line_id = psl.summary_line_id
5508: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
5509: AND palh.adjustment_batch_name IS NULL
5510: AND palh.reversal_entry_flag IS NULL

Line 5544: FROM psp_adjustment_lines_history palh

5540: AND ppg.distribution_date BETWEEN p_effort_start AND p_effort_end
5541: AND ppg.adjustment_batch_name IS NULL
5542: AND ppg.reversal_entry_flag IS NULL)
5543: OR EXISTS (SELECT 1
5544: FROM psp_adjustment_lines_history palh
5545: WHERE palh.summary_line_id = psl.summary_line_id
5546: AND palh.distribution_date BETWEEN p_effort_start AND p_effort_end
5547: AND palh.adjustment_batch_name IS NULL
5548: AND palh.reversal_entry_flag IS NULL

Line 5738: psp_adjustment_lines_history palh,

5734: g_exec_string := 'DELETE FROM psp_selected_persons_t
5735: WHERE assignment_id IN (SELECT NVL(psl.assignment_id,0)
5736: FROM psp_summary_lines psl,
5737: psp_distribution_lines_history pdnh,
5738: psp_adjustment_lines_history palh,
5739: psp_pre_gen_dist_lines_history ppg,
5740: gl_code_combinations gcc
5741: WHERE gcc.code_combination_id= psl.gl_code_combination_id
5742: AND psl.business_group_id = '|| p_business_group_id || '