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_PRE_GEN_DIST_LINES_HISTORY

Line 543: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

539: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
540: AND pdnh.reversal_entry_flag IS NULL
541: AND pdnh.adjustment_batch_name IS NULL )
542: OR EXISTS
543: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 582: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

578: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
579: AND pdnh.reversal_entry_flag IS NULL
580: AND pdnh.adjustment_batch_name IS NULL )
581: OR EXISTS
582: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 619: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

615: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
616: AND pdnh.reversal_entry_flag IS NULL
617: AND pdnh.adjustment_batch_name IS NULL )
618: OR EXISTS
619: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 655: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

651: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
652: AND pdnh.reversal_entry_flag IS NULL
653: AND pdnh.adjustment_batch_name IS NULL )
654: OR EXISTS
655: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 965: from psp_summary_lines psl, psp_distribution_lines_history pdnh, psp_pre_gen_dist_lines_history ppg,

961: -- fnd_file.put_line(fnd_file.log,' before isnerting g_exec_string in GL criteria ');
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

Line 1076: FROM psp_pre_gen_dist_lines_history

1072: AND paf.effective_end_date >= p_effort_start
1073: AND paf.assignment_status_type_id = past.assignment_status_type_id
1074: AND ( past.per_system_status <> 'TERM_ASSIGN'
1075: OR EXISTS ( select null
1076: FROM psp_pre_gen_dist_lines_history
1077: WHERE distribution_date between p_effort_start and p_effort_end
1078: AND assignment_id = paf.assignment_id
1079: AND reversal_entry_flag IS NULL
1080: AND rownum=1 )

Line 1113: FROM psp_pre_gen_dist_lines_history

1109: AND paf.effective_end_date >= p_effort_start
1110: AND paf.assignment_status_type_id = past.assignment_status_type_id
1111: AND ( past.per_system_status <> 'TERM_ASSIGN'
1112: OR EXISTS ( select null
1113: FROM psp_pre_gen_dist_lines_history
1114: WHERE distribution_date between p_effort_start and p_effort_end
1115: AND assignment_id = paf.assignment_id
1116: AND reversal_entry_flag IS NULL
1117: AND rownum=1 )

Line 1150: FROM psp_pre_gen_dist_lines_history

1146: AND paf.effective_end_date >= p_effort_start
1147: AND paf.assignment_status_type_id = past.assignment_status_type_id
1148: AND ( past.per_system_status <> 'TERM_ASSIGN'
1149: OR EXISTS ( select null
1150: FROM psp_pre_gen_dist_lines_history
1151: WHERE distribution_date between p_effort_start and p_effort_end
1152: AND assignment_id = paf.assignment_id
1153: AND reversal_entry_flag IS NULL
1154: AND rownum=1 )

Line 1196: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

1192: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
1193: AND pdnh.reversal_entry_flag IS NULL
1194: AND pdnh.adjustment_batch_name IS NULL )
1195: OR EXISTS
1196: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 1239: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

1235: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
1236: AND pdnh.reversal_entry_flag IS NULL
1237: AND pdnh.adjustment_batch_name IS NULL )
1238: OR EXISTS
1239: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 1282: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

1278: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
1279: AND pdnh.reversal_entry_flag IS NULL
1280: AND pdnh.adjustment_batch_name IS NULL )
1281: OR EXISTS
1282: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 1329: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

1325: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
1326: AND pdnh.reversal_entry_flag IS NULL
1327: AND pdnh.adjustment_batch_name IS NULL )
1328: OR EXISTS
1329: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 1363: FROM psp_pre_gen_dist_lines_history

1359: AND paf.effective_end_date >= p_effort_start
1360: AND paf.assignment_status_type_id = past.assignment_status_type_id
1361: AND ( past.per_system_status <> 'TERM_ASSIGN'
1362: OR EXISTS ( select null
1363: FROM psp_pre_gen_dist_lines_history
1364: WHERE distribution_date between p_effort_start and p_effort_end
1365: AND assignment_id = paf.assignment_id
1366: AND reversal_entry_flag IS NULL
1367: AND rownum=1 )

Line 1400: FROM psp_pre_gen_dist_lines_history

1396: AND paf.effective_end_date >= p_effort_start
1397: AND paf.assignment_status_type_id = past.assignment_status_type_id
1398: AND ( past.per_system_status <> 'TERM_ASSIGN'
1399: OR EXISTS ( select null
1400: FROM psp_pre_gen_dist_lines_history
1401: WHERE distribution_date between p_effort_start and p_effort_end
1402: AND assignment_id = paf.assignment_id
1403: AND reversal_entry_flag IS NULL
1404: AND rownum=1 )

Line 1437: FROM psp_pre_gen_dist_lines_history

1433: AND paf.effective_end_date >= p_effort_start
1434: AND paf.assignment_status_type_id = past.assignment_status_type_id
1435: AND ( past.per_system_status <> 'TERM_ASSIGN'
1436: OR EXISTS ( select null
1437: FROM psp_pre_gen_dist_lines_history
1438: WHERE distribution_date between p_effort_start and p_effort_end
1439: AND assignment_id = paf.assignment_id
1440: AND reversal_entry_flag IS NULL
1441: AND rownum=1 )

Line 1478: FROM psp_pre_gen_dist_lines_history

1474: AND paf.effective_end_date >= p_effort_start
1475: AND paf.assignment_status_type_id = past.assignment_status_type_id
1476: AND ( past.per_system_status <> 'TERM_ASSIGN'
1477: OR EXISTS ( select null
1478: FROM psp_pre_gen_dist_lines_history
1479: WHERE distribution_date between p_effort_start and p_effort_end
1480: AND assignment_id = paf.assignment_id
1481: AND reversal_entry_flag IS NULL
1482: AND rownum=1 )

Line 1530: FROM psp_pre_gen_dist_lines_history

1526: AND ppf.effective_end_date >= p_effort_start
1527: AND paf.assignment_status_type_id = past.assignment_status_type_id
1528: AND ( past.per_system_status <> 'TERM_ASSIGN'
1529: OR EXISTS ( select null
1530: FROM psp_pre_gen_dist_lines_history
1531: WHERE distribution_date between p_effort_start and p_effort_end
1532: AND assignment_id = paf.assignment_id
1533: AND reversal_entry_flag IS NULL
1534: AND rownum=1 )

Line 1568: FROM psp_pre_gen_dist_lines_history

1564: AND paf.effective_end_date >= p_effort_start
1565: AND paf.assignment_status_type_id = past.assignment_status_type_id
1566: AND ( past.per_system_status <> 'TERM_ASSIGN'
1567: OR EXISTS ( select null
1568: FROM psp_pre_gen_dist_lines_history
1569: WHERE distribution_date between p_effort_start and p_effort_end
1570: AND assignment_id = paf.assignment_id
1571: AND reversal_entry_flag IS NULL
1572: AND rownum=1 )

Line 1605: FROM psp_pre_gen_dist_lines_history

1601: AND paf.effective_end_date >= p_effort_start
1602: AND paf.assignment_status_type_id = past.assignment_status_type_id
1603: AND ( past.per_system_status <> 'TERM_ASSIGN'
1604: OR EXISTS ( select null
1605: FROM psp_pre_gen_dist_lines_history
1606: WHERE distribution_date between p_effort_start and p_effort_end
1607: AND assignment_id = paf.assignment_id
1608: AND reversal_entry_flag IS NULL
1609: AND rownum=1 )

Line 1643: FROM psp_pre_gen_dist_lines_history

1639: AND ppf.business_group_id = p_business_group_id
1640: AND paf.assignment_status_type_id = past.assignment_status_type_id
1641: AND ( past.per_system_status <> 'TERM_ASSIGN'
1642: OR EXISTS ( select null
1643: FROM psp_pre_gen_dist_lines_history
1644: WHERE distribution_date between p_effort_start and p_effort_end
1645: AND assignment_id = paf.assignment_id
1646: AND reversal_entry_flag IS NULL
1647: AND rownum=1 )

Line 1710: FROM psp_pre_gen_dist_lines_history

1706: AND ppg.people_group_id IN (SELECT people_group_id FROM pay_people_groups
1707: WHERE ' || l_sql_string|| ' )
1708: AND ( past.per_system_status <> '''|| 'TERM_ASSIGN' ||'''
1709: OR EXISTS ( select null
1710: FROM psp_pre_gen_dist_lines_history
1711: WHERE distribution_date between :p_effort_start and :p_effort_end
1712: AND assignment_id = paf.assignment_id
1713: AND reversal_entry_flag IS NULL
1714: AND rownum=1 )

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 1904: FROM psp_pre_gen_dist_lines_history

1900: AND ppf.person_id = pspt.person_id
1901: AND paf.assignment_status_type_id = past.assignment_status_type_id
1902: AND ( past.per_system_status <> 'TERM_ASSIGN'
1903: OR EXISTS ( select null
1904: FROM psp_pre_gen_dist_lines_history
1905: WHERE distribution_date between p_effort_start and p_effort_end
1906: AND assignment_id = paf.assignment_id
1907: AND reversal_entry_flag IS NULL
1908: AND rownum=1 )

Line 1945: FROM psp_pre_gen_dist_lines_history

1941: AND ppf.person_id = pspt.person_id
1942: AND paf.assignment_status_type_id = past.assignment_status_type_id
1943: AND ( past.per_system_status <> 'TERM_ASSIGN'
1944: OR EXISTS ( select null
1945: FROM psp_pre_gen_dist_lines_history
1946: WHERE distribution_date between p_effort_start and p_effort_end
1947: AND assignment_id = paf.assignment_id
1948: AND reversal_entry_flag IS NULL
1949: AND rownum=1 )

Line 1983: FROM psp_pre_gen_dist_lines_history

1979: AND paf.person_id = pspt.person_id
1980: AND paf.assignment_status_type_id = past.assignment_status_type_id
1981: AND ( past.per_system_status <> 'TERM_ASSIGN'
1982: OR EXISTS ( select null
1983: FROM psp_pre_gen_dist_lines_history
1984: WHERE distribution_date between p_effort_start and p_effort_end
1985: AND assignment_id = paf.assignment_id
1986: AND reversal_entry_flag IS NULL
1987: AND rownum=1 )

Line 2025: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

2021: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
2022: AND pdnh.reversal_entry_flag IS NULL
2023: AND pdnh.adjustment_batch_name IS NULL )
2024: OR EXISTS
2025: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 2064: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

2060: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
2061: AND pdnh.reversal_entry_flag IS NULL
2062: AND pdnh.adjustment_batch_name IS NULL )
2063: OR EXISTS
2064: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 2102: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

2098: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
2099: AND pdnh.reversal_entry_flag IS NULL
2100: AND pdnh.adjustment_batch_name IS NULL )
2101: OR EXISTS
2102: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 2139: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

2135: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
2136: AND pdnh.reversal_entry_flag IS NULL
2137: AND pdnh.adjustment_batch_name IS NULL )
2138: OR EXISTS
2139: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 2173: FROM psp_pre_gen_dist_lines_history

2169: AND paf.person_id = pspt.person_id
2170: AND paf.assignment_status_type_id = past.assignment_status_type_id
2171: AND ( past.per_system_status <> 'TERM_ASSIGN'
2172: OR EXISTS ( select null
2173: FROM psp_pre_gen_dist_lines_history
2174: WHERE distribution_date between p_effort_start and p_effort_end
2175: AND assignment_id = paf.assignment_id
2176: AND reversal_entry_flag IS NULL
2177: AND rownum=1 )

Line 2212: FROM psp_pre_gen_dist_lines_history

2208: AND paf.person_id = pspt.person_id
2209: AND paf.assignment_status_type_id = past.assignment_status_type_id
2210: AND ( past.per_system_status <> 'TERM_ASSIGN'
2211: OR EXISTS ( select null
2212: FROM psp_pre_gen_dist_lines_history
2213: WHERE distribution_date between p_effort_start and p_effort_end
2214: AND assignment_id = paf.assignment_id
2215: AND reversal_entry_flag IS NULL
2216: AND rownum=1 )

Line 2248: FROM psp_pre_gen_dist_lines_history

2244: AND paf.person_id = pspt.person_id
2245: AND paf.assignment_status_type_id = past.assignment_status_type_id
2246: AND ( past.per_system_status <> 'TERM_ASSIGN'
2247: OR EXISTS ( select null
2248: FROM psp_pre_gen_dist_lines_history
2249: WHERE distribution_date between p_effort_start and p_effort_end
2250: AND assignment_id = paf.assignment_id
2251: AND reversal_entry_flag IS NULL
2252: AND rownum=1 )

Line 2289: FROM psp_pre_gen_dist_lines_history

2285: AND paf.person_id = pspt.person_id
2286: AND paf.assignment_status_type_id = past.assignment_status_type_id
2287: AND ( past.per_system_status <> 'TERM_ASSIGN'
2288: OR EXISTS ( select null
2289: FROM psp_pre_gen_dist_lines_history
2290: WHERE distribution_date between p_effort_start and p_effort_end
2291: AND assignment_id = paf.assignment_id
2292: AND reversal_entry_flag IS NULL
2293: AND rownum=1 )

Line 2341: FROM psp_pre_gen_dist_lines_history

2337: AND paf.effective_end_date >= p_effort_start)
2338: AND paf.assignment_status_type_id = past.assignment_status_type_id
2339: AND ( past.per_system_status <> 'TERM_ASSIGN'
2340: OR EXISTS ( select null
2341: FROM psp_pre_gen_dist_lines_history
2342: WHERE distribution_date between p_effort_start and p_effort_end
2343: AND assignment_id = paf.assignment_id
2344: AND reversal_entry_flag IS NULL
2345: AND rownum=1 )

Line 2379: FROM psp_pre_gen_dist_lines_history

2375: AND paf.person_id = pspt.person_id
2376: AND paf.assignment_status_type_id = past.assignment_status_type_id
2377: AND ( past.per_system_status <> 'TERM_ASSIGN'
2378: OR EXISTS ( select null
2379: FROM psp_pre_gen_dist_lines_history
2380: WHERE distribution_date between p_effort_start and p_effort_end
2381: AND assignment_id = paf.assignment_id
2382: AND reversal_entry_flag IS NULL
2383: AND rownum=1 )

Line 2417: FROM psp_pre_gen_dist_lines_history

2413: AND paf.person_id = pspt.person_id
2414: AND paf.assignment_status_type_id = past.assignment_status_type_id
2415: AND ( past.per_system_status <> 'TERM_ASSIGN'
2416: OR EXISTS ( select null
2417: FROM psp_pre_gen_dist_lines_history
2418: WHERE distribution_date between p_effort_start and p_effort_end
2419: AND assignment_id = paf.assignment_id
2420: AND reversal_entry_flag IS NULL
2421: AND rownum=1 )

Line 2455: FROM psp_pre_gen_dist_lines_history

2451: AND paf.person_id = pspt.person_id
2452: AND paf.assignment_status_type_id = past.assignment_status_type_id
2453: AND ( past.per_system_status <> 'TERM_ASSIGN'
2454: OR EXISTS ( select null
2455: FROM psp_pre_gen_dist_lines_history
2456: WHERE distribution_date between p_effort_start and p_effort_end
2457: AND assignment_id = paf.assignment_id
2458: AND reversal_entry_flag IS NULL
2459: AND rownum=1 )

Line 2526: FROM psp_pre_gen_dist_lines_history

2522: AND paf.person_id = sel.person_id
2523: AND paf.assignment_status_type_id = past.assignment_status_type_id
2524: AND ( past.per_system_status <> ''' || 'TERM_ASSIGN' || '''
2525: OR EXISTS ( select null
2526: FROM psp_pre_gen_dist_lines_history
2527: WHERE distribution_date between :p_effort_start and :p_effort_end
2528: AND assignment_id = paf.assignment_id
2529: AND reversal_entry_flag IS NULL
2530: AND rownum=1 )

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 2693: FROM psp_pre_gen_dist_lines_history

2689: AND prtd.request_id = p_request_id
2690: AND paf.assignment_status_type_id = past.assignment_status_type_id
2691: AND ( past.per_system_status <> 'TERM_ASSIGN'
2692: OR EXISTS ( select null
2693: FROM psp_pre_gen_dist_lines_history
2694: WHERE distribution_date between p_effort_start and p_effort_end
2695: AND assignment_id = paf.assignment_id
2696: AND reversal_entry_flag IS NULL
2697: AND rownum=1 )

Line 2732: FROM psp_pre_gen_dist_lines_history

2728: AND ppf.effective_end_date >= p_effort_start
2729: AND paf.assignment_status_type_id = past.assignment_status_type_id
2730: AND ( past.per_system_status <> 'TERM_ASSIGN'
2731: OR EXISTS ( select null
2732: FROM psp_pre_gen_dist_lines_history
2733: WHERE distribution_date between p_effort_start and p_effort_end
2734: AND assignment_id = paf.assignment_id
2735: AND reversal_entry_flag IS NULL
2736: AND rownum=1 )

Line 2767: FROM psp_pre_gen_dist_lines_history

2763: AND paf.effective_end_date >= p_effort_start
2764: AND paf.assignment_status_type_id = past.assignment_status_type_id
2765: AND ( past.per_system_status <> 'TERM_ASSIGN'
2766: OR EXISTS ( select null
2767: FROM psp_pre_gen_dist_lines_history
2768: WHERE distribution_date between p_effort_start and p_effort_end
2769: AND assignment_id = paf.assignment_id
2770: AND reversal_entry_flag IS NULL
2771: AND rownum=1 )

Line 2808: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

2804: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
2805: AND pdnh.reversal_entry_flag IS NULL
2806: AND pdnh.adjustment_batch_name IS NULL )
2807: OR EXISTS
2808: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 2846: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

2842: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
2843: AND pdnh.reversal_entry_flag IS NULL
2844: AND pdnh.adjustment_batch_name IS NULL )
2845: OR EXISTS
2846: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 2884: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

2880: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
2881: AND pdnh.reversal_entry_flag IS NULL
2882: AND pdnh.adjustment_batch_name IS NULL )
2883: OR EXISTS
2884: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 2921: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

2917: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
2918: AND pdnh.reversal_entry_flag IS NULL
2919: AND pdnh.adjustment_batch_name IS NULL )
2920: OR EXISTS
2921: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 2953: FROM psp_pre_gen_dist_lines_history

2949: AND prtd.request_id = p_request_id
2950: AND paf.assignment_status_type_id = past.assignment_status_type_id
2951: AND ( past.per_system_status <> 'TERM_ASSIGN'
2952: OR EXISTS ( select null
2953: FROM psp_pre_gen_dist_lines_history
2954: WHERE distribution_date between p_effort_start and p_effort_end
2955: AND assignment_id = paf.assignment_id
2956: AND reversal_entry_flag IS NULL
2957: AND rownum=1 )

Line 2988: FROM psp_pre_gen_dist_lines_history

2984: AND prtd.request_id = p_request_id
2985: AND paf.assignment_status_type_id = past.assignment_status_type_id
2986: AND ( past.per_system_status <> 'TERM_ASSIGN'
2987: OR EXISTS ( select null
2988: FROM psp_pre_gen_dist_lines_history
2989: WHERE distribution_date between p_effort_start and p_effort_end
2990: AND assignment_id = paf.assignment_id
2991: AND reversal_entry_flag IS NULL
2992: AND rownum=1 )

Line 3023: FROM psp_pre_gen_dist_lines_history

3019: AND prtd.request_id = p_request_id
3020: AND paf.assignment_status_type_id = past.assignment_status_type_id
3021: AND ( past.per_system_status <> 'TERM_ASSIGN'
3022: OR EXISTS ( select null
3023: FROM psp_pre_gen_dist_lines_history
3024: WHERE distribution_date between p_effort_start and p_effort_end
3025: AND assignment_id = paf.assignment_id
3026: AND reversal_entry_flag IS NULL
3027: AND rownum=1 )

Line 3062: FROM psp_pre_gen_dist_lines_history

3058: AND prtd.request_id = p_request_id
3059: AND paf.assignment_status_type_id = past.assignment_status_type_id
3060: AND ( past.per_system_status <> 'TERM_ASSIGN'
3061: OR EXISTS ( select null
3062: FROM psp_pre_gen_dist_lines_history
3063: WHERE distribution_date between p_effort_start and p_effort_end
3064: AND assignment_id = paf.assignment_id
3065: AND reversal_entry_flag IS NULL
3066: AND rownum=1 )

Line 3097: FROM psp_pre_gen_dist_lines_history

3093: AND prtd.request_id = p_request_id
3094: AND paf.assignment_status_type_id = past.assignment_status_type_id
3095: AND ( past.per_system_status <> 'TERM_ASSIGN'
3096: OR EXISTS ( select null
3097: FROM psp_pre_gen_dist_lines_history
3098: WHERE distribution_date between p_effort_start and p_effort_end
3099: AND assignment_id = paf.assignment_id
3100: AND reversal_entry_flag IS NULL
3101: AND rownum=1 )

Line 3131: FROM psp_pre_gen_dist_lines_history

3127: AND effective_end_date >= p_effort_start
3128: AND paf.assignment_status_type_id = past.assignment_status_type_id
3129: AND ( past.per_system_status <> 'TERM_ASSIGN'
3130: OR EXISTS ( select null
3131: FROM psp_pre_gen_dist_lines_history
3132: WHERE distribution_date between p_effort_start and p_effort_end
3133: AND assignment_id = paf.assignment_id
3134: AND reversal_entry_flag IS NULL
3135: AND rownum=1 )

Line 3170: FROM psp_pre_gen_dist_lines_history

3166: AND paf.effective_end_date >= p_effort_start
3167: AND paf.assignment_status_type_id = past.assignment_status_type_id
3168: AND ( past.per_system_status <> 'TERM_ASSIGN'
3169: OR EXISTS ( select null
3170: FROM psp_pre_gen_dist_lines_history
3171: WHERE distribution_date between p_effort_start and p_effort_end
3172: AND assignment_id = paf.assignment_id
3173: AND reversal_entry_flag IS NULL
3174: AND rownum=1 )

Line 3223: FROM psp_pre_gen_dist_lines_history

3219: AND paf.effective_end_date >= p_effort_start)
3220: AND paf.assignment_status_type_id = past.assignment_status_type_id
3221: AND ( past.per_system_status <> 'TERM_ASSIGN'
3222: OR EXISTS ( select null
3223: FROM psp_pre_gen_dist_lines_history
3224: WHERE distribution_date between p_effort_start and p_effort_end
3225: AND assignment_id = paf.assignment_id
3226: AND reversal_entry_flag IS NULL
3227: AND rownum=1 )

Line 3287: FROM psp_pre_gen_dist_lines_history

3283: || ' )
3284: AND paf.assignment_status_type_id = past.assignment_status_type_id
3285: AND ( past.per_system_status <> ''' || 'TERM_ASSIGN' || '''
3286: OR EXISTS ( select null
3287: FROM psp_pre_gen_dist_lines_history
3288: WHERE distribution_date between :p_effort_start and :p_effort_end
3289: AND assignment_id = paf.assignment_id
3290: AND reversal_entry_flag IS NULL
3291: AND rownum=1 )

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 3699: FROM psp_pre_gen_dist_lines_history ppg

3695: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
3696: AND pdnh.reversal_entry_flag IS NULL
3697: AND pdnh.adjustment_batch_name IS NULL )
3698: OR EXISTS (SELECT 1
3699: FROM psp_pre_gen_dist_lines_history ppg
3700: WHERE ppg.summary_line_id = psl.summary_line_id
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)

Line 3738: FROM psp_pre_gen_dist_lines_history ppg

3734: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
3735: AND pdnh.reversal_entry_flag IS NULL
3736: AND pdnh.adjustment_batch_name IS NULL )
3737: OR EXISTS (SELECT 1
3738: FROM psp_pre_gen_dist_lines_history ppg
3739: WHERE ppg.summary_line_id = psl.summary_line_id
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)

Line 3777: FROM psp_pre_gen_dist_lines_history ppg

3773: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
3774: AND pdnh.reversal_entry_flag IS NULL
3775: AND pdnh.adjustment_batch_name IS NULL )
3776: OR EXISTS (SELECT 1
3777: FROM psp_pre_gen_dist_lines_history ppg
3778: WHERE ppg.summary_line_id = psl.summary_line_id
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)

Line 3813: OR EXISTS (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

3809: WHERE pdnh.summary_line_id = psl.summary_line_id
3810: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
3811: AND pdnh.reversal_entry_flag IS NULL
3812: AND pdnh.adjustment_batch_name IS NULL )
3813: OR EXISTS (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 4049: psp_pre_gen_dist_lines_history ppg,

4045: g_exec_string := 'INSERT INTO psp_selection_cardinality_gt(lookup_code, total_count)
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 || '

Line 4152: FROM psp_pre_gen_dist_lines_history

4148: AND paf.effective_end_date >= p_effort_start
4149: AND paf.assignment_status_type_id = past.assignment_status_type_id
4150: AND ( past.per_system_status <> 'TERM_ASSIGN'
4151: OR EXISTS ( select null
4152: FROM psp_pre_gen_dist_lines_history
4153: WHERE distribution_date between p_effort_start and p_effort_end
4154: AND assignment_id = paf.assignment_id
4155: AND reversal_entry_flag IS NULL
4156: AND rownum=1 )

Line 4189: FROM psp_pre_gen_dist_lines_history

4185: AND paf.effective_end_date >= p_effort_start
4186: AND paf.assignment_status_type_id = past.assignment_status_type_id
4187: AND ( past.per_system_status <> 'TERM_ASSIGN'
4188: OR EXISTS ( select null
4189: FROM psp_pre_gen_dist_lines_history
4190: WHERE distribution_date between p_effort_start and p_effort_end
4191: AND assignment_id = paf.assignment_id
4192: AND reversal_entry_flag IS NULL
4193: AND rownum=1 )

Line 4222: FROM psp_pre_gen_dist_lines_history

4218: AND paf.effective_end_date >= p_effort_start
4219: AND paf.assignment_status_type_id = past.assignment_status_type_id
4220: AND ( past.per_system_status <> 'TERM_ASSIGN'
4221: OR EXISTS ( select null
4222: FROM psp_pre_gen_dist_lines_history
4223: WHERE distribution_date between p_effort_start and p_effort_end
4224: AND assignment_id = paf.assignment_id
4225: AND reversal_entry_flag IS NULL
4226: AND rownum=1 )

Line 4261: FROM psp_pre_gen_dist_lines_history ppg

4257: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
4258: AND pdnh.reversal_entry_flag IS NULL
4259: AND pdnh.adjustment_batch_name IS NULL )
4260: OR EXISTS (SELECT 1
4261: FROM psp_pre_gen_dist_lines_history ppg
4262: WHERE ppg.summary_line_id = psl.summary_line_id
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)

Line 4298: FROM psp_pre_gen_dist_lines_history ppg

4294: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
4295: AND pdnh.reversal_entry_flag IS NULL
4296: AND pdnh.adjustment_batch_name IS NULL )
4297: OR EXISTS (SELECT 1
4298: FROM psp_pre_gen_dist_lines_history ppg
4299: WHERE ppg.summary_line_id = psl.summary_line_id
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)

Line 4336: FROM psp_pre_gen_dist_lines_history ppg

4332: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
4333: AND pdnh.reversal_entry_flag IS NULL
4334: AND pdnh.adjustment_batch_name IS NULL )
4335: OR EXISTS (SELECT 1
4336: FROM psp_pre_gen_dist_lines_history ppg
4337: WHERE ppg.summary_line_id = psl.summary_line_id
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)

Line 4372: FROM psp_pre_gen_dist_lines_history ppg

4368: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
4369: AND pdnh.reversal_entry_flag IS NULL
4370: AND pdnh.adjustment_batch_name IS NULL )
4371: OR EXISTS (SELECT 1
4372: FROM psp_pre_gen_dist_lines_history ppg
4373: WHERE ppg.summary_line_id = psl.summary_line_id
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)

Line 4402: FROM psp_pre_gen_dist_lines_history

4398: AND paf.effective_end_date >= p_effort_start
4399: AND paf.assignment_status_type_id = past.assignment_status_type_id
4400: AND ( past.per_system_status <> 'TERM_ASSIGN'
4401: OR EXISTS ( select null
4402: FROM psp_pre_gen_dist_lines_history
4403: WHERE distribution_date between p_effort_start and p_effort_end
4404: AND assignment_id = paf.assignment_id
4405: AND reversal_entry_flag IS NULL
4406: AND rownum=1 )

Line 4435: FROM psp_pre_gen_dist_lines_history

4431: AND paf.effective_end_date >= p_effort_start
4432: AND paf.assignment_status_type_id = past.assignment_status_type_id
4433: AND ( past.per_system_status <> 'TERM_ASSIGN'
4434: OR EXISTS ( select null
4435: FROM psp_pre_gen_dist_lines_history
4436: WHERE distribution_date between p_effort_start and p_effort_end
4437: AND assignment_id = paf.assignment_id
4438: AND reversal_entry_flag IS NULL
4439: AND rownum=1 )

Line 4467: FROM psp_pre_gen_dist_lines_history

4463: AND paf.effective_end_date >= p_effort_start
4464: AND paf.assignment_status_type_id = past.assignment_status_type_id
4465: AND ( past.per_system_status <> 'TERM_ASSIGN'
4466: OR EXISTS ( select null
4467: FROM psp_pre_gen_dist_lines_history
4468: WHERE distribution_date between p_effort_start and p_effort_end
4469: AND assignment_id = paf.assignment_id
4470: AND reversal_entry_flag IS NULL
4471: AND rownum=1 )

Line 4503: FROM psp_pre_gen_dist_lines_history

4499: AND paf.effective_end_date >= p_effort_start
4500: AND paf.assignment_status_type_id = past.assignment_status_type_id
4501: AND ( past.per_system_status <> 'TERM_ASSIGN'
4502: OR EXISTS ( select null
4503: FROM psp_pre_gen_dist_lines_history
4504: WHERE distribution_date between p_effort_start and p_effort_end
4505: AND assignment_id = paf.assignment_id
4506: AND reversal_entry_flag IS NULL
4507: AND rownum=1 )

Line 4551: FROM psp_pre_gen_dist_lines_history

4547: AND paf.effective_end_date >= p_effort_start)
4548: AND paf.assignment_status_type_id = past.assignment_status_type_id
4549: AND ( past.per_system_status <> 'TERM_ASSIGN'
4550: OR EXISTS ( select null
4551: FROM psp_pre_gen_dist_lines_history
4552: WHERE distribution_date between p_effort_start and p_effort_end
4553: AND assignment_id = paf.assignment_id
4554: AND reversal_entry_flag IS NULL
4555: AND rownum=1 )

Line 4584: FROM psp_pre_gen_dist_lines_history

4580: AND paf.effective_end_date >= p_effort_start
4581: AND paf.assignment_status_type_id = past.assignment_status_type_id
4582: AND ( past.per_system_status <> 'TERM_ASSIGN'
4583: OR EXISTS ( select null
4584: FROM psp_pre_gen_dist_lines_history
4585: WHERE distribution_date between p_effort_start and p_effort_end
4586: AND assignment_id = paf.assignment_id
4587: AND reversal_entry_flag IS NULL
4588: AND rownum=1 )

Line 4616: FROM psp_pre_gen_dist_lines_history

4612: AND paf.effective_end_date >= p_effort_start
4613: AND paf.assignment_status_type_id = past.assignment_status_type_id
4614: AND ( past.per_system_status <> 'TERM_ASSIGN'
4615: OR EXISTS ( select null
4616: FROM psp_pre_gen_dist_lines_history
4617: WHERE distribution_date between p_effort_start and p_effort_end
4618: AND assignment_id = paf.assignment_id
4619: AND reversal_entry_flag IS NULL
4620: AND rownum=1 )

Line 4648: FROM psp_pre_gen_dist_lines_history

4644: AND paf.effective_end_date >= p_effort_start
4645: AND paf.assignment_status_type_id = past.assignment_status_type_id
4646: AND ( past.per_system_status <> 'TERM_ASSIGN'
4647: OR EXISTS ( select null
4648: FROM psp_pre_gen_dist_lines_history
4649: WHERE distribution_date between p_effort_start and p_effort_end
4650: AND assignment_id = paf.assignment_id
4651: AND reversal_entry_flag IS NULL
4652: AND rownum=1 )

Line 4696: FROM psp_pre_gen_dist_lines_history

4692: WHERE ' || l_sql_string || ')
4693: AND paf.assignment_status_type_id = past.assignment_status_type_id
4694: AND ( past.per_system_status <> ''' ||'TERM_ASSIGN' || '''
4695: OR EXISTS ( select null
4696: FROM psp_pre_gen_dist_lines_history
4697: WHERE distribution_date between :p_effort_start and :p_effort_end
4698: AND assignment_id = paf.assignment_id
4699: AND reversal_entry_flag IS NULL
4700: AND rownum=1 )

Line 4739: psp_pre_gen_dist_lines_history ppg,

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 ||'
4743: AND psl.summary_line_id = pdnh.summary_line_id(+)

Line 4917: FROM psp_pre_gen_dist_lines_history ppg

4913: AND p_effort_end
4914: AND pdnh.reversal_entry_flag IS NULL
4915: AND pdnh.adjustment_batch_name IS NULL)
4916: OR EXISTS (SELECT 1
4917: FROM psp_pre_gen_dist_lines_history ppg
4918: WHERE ppg.summary_line_id = psl.summary_line_id
4919: AND ppg.distribution_date BETWEEN p_effort_start
4920: AND p_effort_end
4921: AND ppg.adjustment_batch_name IS NULL

Line 4959: FROM psp_pre_gen_dist_lines_history ppg

4955: AND p_effort_end
4956: AND pdnh.reversal_entry_flag IS NULL
4957: AND pdnh.adjustment_batch_name IS NULL)
4958: OR EXISTS (SELECT 1
4959: FROM psp_pre_gen_dist_lines_history ppg
4960: WHERE ppg.summary_line_id = psl.summary_line_id
4961: AND ppg.distribution_date BETWEEN p_effort_start
4962: AND p_effort_end
4963: AND ppg.adjustment_batch_name IS NULL

Line 5001: FROM psp_pre_gen_dist_lines_history ppg

4997: AND p_effort_end
4998: AND pdnh.reversal_entry_flag IS NULL
4999: AND pdnh.adjustment_batch_name IS NULL)
5000: OR EXISTS (SELECT 1
5001: FROM psp_pre_gen_dist_lines_history ppg
5002: WHERE ppg.summary_line_id = psl.summary_line_id
5003: AND ppg.distribution_date BETWEEN p_effort_start
5004: AND p_effort_end
5005: AND ppg.adjustment_batch_name IS NULL

Line 5042: FROM psp_pre_gen_dist_lines_history ppg

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

Line 5271: psp_pre_gen_dist_lines_history ppg, gl_code_combinations gcc

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 || '
5275: AND psl.summary_line_id = pdnh.summary_line_id(+)

Line 5422: FROM psp_pre_gen_dist_lines_history ppg

5418: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
5419: AND pdnh.reversal_entry_flag IS NULL
5420: AND pdnh.adjustment_batch_name IS NULL)
5421: OR EXISTS (SELECT 1
5422: FROM psp_pre_gen_dist_lines_history ppg
5423: WHERE ppg.summary_line_id = psl.summary_line_id
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)

Line 5461: FROM psp_pre_gen_dist_lines_history ppg

5457: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
5458: AND pdnh.reversal_entry_flag IS NULL
5459: AND pdnh.adjustment_batch_name IS NULL)
5460: OR EXISTS (SELECT 1
5461: FROM psp_pre_gen_dist_lines_history ppg
5462: WHERE ppg.summary_line_id = psl.summary_line_id
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)

Line 5500: FROM psp_pre_gen_dist_lines_history ppg

5496: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
5497: AND pdnh.reversal_entry_flag IS NULL
5498: AND pdnh.adjustment_batch_name IS NULL)
5499: OR EXISTS (SELECT 1
5500: FROM psp_pre_gen_dist_lines_history ppg
5501: WHERE ppg.summary_line_id = psl.summary_line_id
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)

Line 5538: FROM psp_pre_gen_dist_lines_history ppg

5534: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
5535: AND pdnh.reversal_entry_flag IS NULL
5536: AND pdnh.adjustment_batch_name IS NULL)
5537: OR EXISTS (SELECT 1
5538: FROM psp_pre_gen_dist_lines_history ppg
5539: WHERE ppg.summary_line_id = psl.summary_line_id
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)

Line 5739: psp_pre_gen_dist_lines_history ppg,

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 || '
5743: AND psl.set_of_books_id = ' || p_set_of_books_id || '