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

1825: AND paf.effective_end_date >= p_effort_start
1826: AND paf.assignment_status_type_id = past.assignment_status_type_id
1827: AND ( past.per_system_status <> 'TERM_ASSIGN'
1828: OR EXISTS ( select null
1829: FROM psp_pre_gen_dist_lines_history
1830: WHERE distribution_date between p_effort_start and p_effort_end
1831: AND assignment_id = paf.assignment_id
1832: AND reversal_entry_flag IS NULL
1833: AND rownum=1 )

Line 1937: FROM psp_pre_gen_dist_lines_history

1933: AND ppf.person_id = pspt.person_id
1934: AND paf.assignment_status_type_id = past.assignment_status_type_id
1935: AND ( past.per_system_status <> 'TERM_ASSIGN'
1936: OR EXISTS ( select null
1937: FROM psp_pre_gen_dist_lines_history
1938: WHERE distribution_date between p_effort_start and p_effort_end
1939: AND assignment_id = paf.assignment_id
1940: AND reversal_entry_flag IS NULL
1941: AND rownum=1 )

Line 1978: FROM psp_pre_gen_dist_lines_history

1974: AND ppf.person_id = pspt.person_id
1975: AND paf.assignment_status_type_id = past.assignment_status_type_id
1976: AND ( past.per_system_status <> 'TERM_ASSIGN'
1977: OR EXISTS ( select null
1978: FROM psp_pre_gen_dist_lines_history
1979: WHERE distribution_date between p_effort_start and p_effort_end
1980: AND assignment_id = paf.assignment_id
1981: AND reversal_entry_flag IS NULL
1982: AND rownum=1 )

Line 2016: FROM psp_pre_gen_dist_lines_history

2012: AND paf.person_id = pspt.person_id
2013: AND paf.assignment_status_type_id = past.assignment_status_type_id
2014: AND ( past.per_system_status <> 'TERM_ASSIGN'
2015: OR EXISTS ( select null
2016: FROM psp_pre_gen_dist_lines_history
2017: WHERE distribution_date between p_effort_start and p_effort_end
2018: AND assignment_id = paf.assignment_id
2019: AND reversal_entry_flag IS NULL
2020: AND rownum=1 )

Line 2058: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

2054: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
2055: AND pdnh.reversal_entry_flag IS NULL
2056: AND pdnh.adjustment_batch_name IS NULL )
2057: OR EXISTS
2058: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 2097: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

2093: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
2094: AND pdnh.reversal_entry_flag IS NULL
2095: AND pdnh.adjustment_batch_name IS NULL )
2096: OR EXISTS
2097: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 2135: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

2131: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
2132: AND pdnh.reversal_entry_flag IS NULL
2133: AND pdnh.adjustment_batch_name IS NULL )
2134: OR EXISTS
2135: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 2172: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

2168: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
2169: AND pdnh.reversal_entry_flag IS NULL
2170: AND pdnh.adjustment_batch_name IS NULL )
2171: OR EXISTS
2172: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 2206: FROM psp_pre_gen_dist_lines_history

2202: AND paf.person_id = pspt.person_id
2203: AND paf.assignment_status_type_id = past.assignment_status_type_id
2204: AND ( past.per_system_status <> 'TERM_ASSIGN'
2205: OR EXISTS ( select null
2206: FROM psp_pre_gen_dist_lines_history
2207: WHERE distribution_date between p_effort_start and p_effort_end
2208: AND assignment_id = paf.assignment_id
2209: AND reversal_entry_flag IS NULL
2210: AND rownum=1 )

Line 2245: FROM psp_pre_gen_dist_lines_history

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

Line 2281: FROM psp_pre_gen_dist_lines_history

2277: AND paf.person_id = pspt.person_id
2278: AND paf.assignment_status_type_id = past.assignment_status_type_id
2279: AND ( past.per_system_status <> 'TERM_ASSIGN'
2280: OR EXISTS ( select null
2281: FROM psp_pre_gen_dist_lines_history
2282: WHERE distribution_date between p_effort_start and p_effort_end
2283: AND assignment_id = paf.assignment_id
2284: AND reversal_entry_flag IS NULL
2285: AND rownum=1 )

Line 2322: FROM psp_pre_gen_dist_lines_history

2318: AND paf.person_id = pspt.person_id
2319: AND paf.assignment_status_type_id = past.assignment_status_type_id
2320: AND ( past.per_system_status <> 'TERM_ASSIGN'
2321: OR EXISTS ( select null
2322: FROM psp_pre_gen_dist_lines_history
2323: WHERE distribution_date between p_effort_start and p_effort_end
2324: AND assignment_id = paf.assignment_id
2325: AND reversal_entry_flag IS NULL
2326: AND rownum=1 )

Line 2374: FROM psp_pre_gen_dist_lines_history

2370: AND paf.effective_end_date >= p_effort_start)
2371: AND paf.assignment_status_type_id = past.assignment_status_type_id
2372: AND ( past.per_system_status <> 'TERM_ASSIGN'
2373: OR EXISTS ( select null
2374: FROM psp_pre_gen_dist_lines_history
2375: WHERE distribution_date between p_effort_start and p_effort_end
2376: AND assignment_id = paf.assignment_id
2377: AND reversal_entry_flag IS NULL
2378: AND rownum=1 )

Line 2412: FROM psp_pre_gen_dist_lines_history

2408: AND paf.person_id = pspt.person_id
2409: AND paf.assignment_status_type_id = past.assignment_status_type_id
2410: AND ( past.per_system_status <> 'TERM_ASSIGN'
2411: OR EXISTS ( select null
2412: FROM psp_pre_gen_dist_lines_history
2413: WHERE distribution_date between p_effort_start and p_effort_end
2414: AND assignment_id = paf.assignment_id
2415: AND reversal_entry_flag IS NULL
2416: AND rownum=1 )

Line 2450: FROM psp_pre_gen_dist_lines_history

2446: AND paf.person_id = pspt.person_id
2447: AND paf.assignment_status_type_id = past.assignment_status_type_id
2448: AND ( past.per_system_status <> 'TERM_ASSIGN'
2449: OR EXISTS ( select null
2450: FROM psp_pre_gen_dist_lines_history
2451: WHERE distribution_date between p_effort_start and p_effort_end
2452: AND assignment_id = paf.assignment_id
2453: AND reversal_entry_flag IS NULL
2454: AND rownum=1 )

Line 2488: FROM psp_pre_gen_dist_lines_history

2484: AND paf.person_id = pspt.person_id
2485: AND paf.assignment_status_type_id = past.assignment_status_type_id
2486: AND ( past.per_system_status <> 'TERM_ASSIGN'
2487: OR EXISTS ( select null
2488: FROM psp_pre_gen_dist_lines_history
2489: WHERE distribution_date between p_effort_start and p_effort_end
2490: AND assignment_id = paf.assignment_id
2491: AND reversal_entry_flag IS NULL
2492: AND rownum=1 )

Line 2559: FROM psp_pre_gen_dist_lines_history

2555: AND paf.person_id = sel.person_id
2556: AND paf.assignment_status_type_id = past.assignment_status_type_id
2557: AND ( past.per_system_status <> ''' || 'TERM_ASSIGN' || '''
2558: OR EXISTS ( select null
2559: FROM psp_pre_gen_dist_lines_history
2560: WHERE distribution_date between :p_effort_start and :p_effort_end
2561: AND assignment_id = paf.assignment_id
2562: AND reversal_entry_flag IS NULL
2563: AND rownum=1 )

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

2722: AND prtd.request_id = p_request_id
2723: AND paf.assignment_status_type_id = past.assignment_status_type_id
2724: AND ( past.per_system_status <> 'TERM_ASSIGN'
2725: OR EXISTS ( select null
2726: FROM psp_pre_gen_dist_lines_history
2727: WHERE distribution_date between p_effort_start and p_effort_end
2728: AND assignment_id = paf.assignment_id
2729: AND reversal_entry_flag IS NULL
2730: AND rownum=1 )

Line 2765: FROM psp_pre_gen_dist_lines_history

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

Line 2800: FROM psp_pre_gen_dist_lines_history

2796: AND paf.effective_end_date >= p_effort_start
2797: AND paf.assignment_status_type_id = past.assignment_status_type_id
2798: AND ( past.per_system_status <> 'TERM_ASSIGN'
2799: OR EXISTS ( select null
2800: FROM psp_pre_gen_dist_lines_history
2801: WHERE distribution_date between p_effort_start and p_effort_end
2802: AND assignment_id = paf.assignment_id
2803: AND reversal_entry_flag IS NULL
2804: AND rownum=1 )

Line 2841: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

2837: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
2838: AND pdnh.reversal_entry_flag IS NULL
2839: AND pdnh.adjustment_batch_name IS NULL )
2840: OR EXISTS
2841: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 2879: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

2875: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
2876: AND pdnh.reversal_entry_flag IS NULL
2877: AND pdnh.adjustment_batch_name IS NULL )
2878: OR EXISTS
2879: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 2917: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

2913: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
2914: AND pdnh.reversal_entry_flag IS NULL
2915: AND pdnh.adjustment_batch_name IS NULL )
2916: OR EXISTS
2917: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 2954: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

2950: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
2951: AND pdnh.reversal_entry_flag IS NULL
2952: AND pdnh.adjustment_batch_name IS NULL )
2953: OR EXISTS
2954: (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 2986: FROM psp_pre_gen_dist_lines_history

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

Line 3021: FROM psp_pre_gen_dist_lines_history

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

Line 3056: FROM psp_pre_gen_dist_lines_history

3052: AND prtd.request_id = p_request_id
3053: AND paf.assignment_status_type_id = past.assignment_status_type_id
3054: AND ( past.per_system_status <> 'TERM_ASSIGN'
3055: OR EXISTS ( select null
3056: FROM psp_pre_gen_dist_lines_history
3057: WHERE distribution_date between p_effort_start and p_effort_end
3058: AND assignment_id = paf.assignment_id
3059: AND reversal_entry_flag IS NULL
3060: AND rownum=1 )

Line 3095: FROM psp_pre_gen_dist_lines_history

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

Line 3130: FROM psp_pre_gen_dist_lines_history

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

Line 3164: FROM psp_pre_gen_dist_lines_history

3160: AND effective_end_date >= p_effort_start
3161: AND paf.assignment_status_type_id = past.assignment_status_type_id
3162: AND ( past.per_system_status <> 'TERM_ASSIGN'
3163: OR EXISTS ( select null
3164: FROM psp_pre_gen_dist_lines_history
3165: WHERE distribution_date between p_effort_start and p_effort_end
3166: AND assignment_id = paf.assignment_id
3167: AND reversal_entry_flag IS NULL
3168: AND rownum=1 )

Line 3203: FROM psp_pre_gen_dist_lines_history

3199: AND paf.effective_end_date >= p_effort_start
3200: AND paf.assignment_status_type_id = past.assignment_status_type_id
3201: AND ( past.per_system_status <> 'TERM_ASSIGN'
3202: OR EXISTS ( select null
3203: FROM psp_pre_gen_dist_lines_history
3204: WHERE distribution_date between p_effort_start and p_effort_end
3205: AND assignment_id = paf.assignment_id
3206: AND reversal_entry_flag IS NULL
3207: AND rownum=1 )

Line 3256: FROM psp_pre_gen_dist_lines_history

3252: AND paf.effective_end_date >= p_effort_start)
3253: AND paf.assignment_status_type_id = past.assignment_status_type_id
3254: AND ( past.per_system_status <> 'TERM_ASSIGN'
3255: OR EXISTS ( select null
3256: FROM psp_pre_gen_dist_lines_history
3257: WHERE distribution_date between p_effort_start and p_effort_end
3258: AND assignment_id = paf.assignment_id
3259: AND reversal_entry_flag IS NULL
3260: AND rownum=1 )

Line 3320: FROM psp_pre_gen_dist_lines_history

3316: || ' )
3317: AND paf.assignment_status_type_id = past.assignment_status_type_id
3318: AND ( past.per_system_status <> ''' || 'TERM_ASSIGN' || '''
3319: OR EXISTS ( select null
3320: FROM psp_pre_gen_dist_lines_history
3321: WHERE distribution_date between :p_effort_start and :p_effort_end
3322: AND assignment_id = paf.assignment_id
3323: AND reversal_entry_flag IS NULL
3324: AND rownum=1 )

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

3728: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
3729: AND pdnh.reversal_entry_flag IS NULL
3730: AND pdnh.adjustment_batch_name IS NULL )
3731: OR EXISTS (SELECT 1
3732: FROM psp_pre_gen_dist_lines_history ppg
3733: WHERE ppg.summary_line_id = psl.summary_line_id
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)

Line 3771: FROM psp_pre_gen_dist_lines_history ppg

3767: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
3768: AND pdnh.reversal_entry_flag IS NULL
3769: AND pdnh.adjustment_batch_name IS NULL )
3770: OR EXISTS (SELECT 1
3771: FROM psp_pre_gen_dist_lines_history ppg
3772: WHERE ppg.summary_line_id = psl.summary_line_id
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)

Line 3810: FROM psp_pre_gen_dist_lines_history ppg

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

Line 3846: OR EXISTS (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg

3842: WHERE pdnh.summary_line_id = psl.summary_line_id
3843: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
3844: AND pdnh.reversal_entry_flag IS NULL
3845: AND pdnh.adjustment_batch_name IS NULL )
3846: OR EXISTS (SELECT 1 FROM psp_pre_gen_dist_lines_history ppg
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)

Line 4082: psp_pre_gen_dist_lines_history ppg,

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

Line 4185: FROM psp_pre_gen_dist_lines_history

4181: AND paf.effective_end_date >= p_effort_start
4182: AND paf.assignment_status_type_id = past.assignment_status_type_id
4183: AND ( past.per_system_status <> 'TERM_ASSIGN'
4184: OR EXISTS ( select null
4185: FROM psp_pre_gen_dist_lines_history
4186: WHERE distribution_date between p_effort_start and p_effort_end
4187: AND assignment_id = paf.assignment_id
4188: AND reversal_entry_flag IS NULL
4189: 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 4255: FROM psp_pre_gen_dist_lines_history

4251: AND paf.effective_end_date >= p_effort_start
4252: AND paf.assignment_status_type_id = past.assignment_status_type_id
4253: AND ( past.per_system_status <> 'TERM_ASSIGN'
4254: OR EXISTS ( select null
4255: FROM psp_pre_gen_dist_lines_history
4256: WHERE distribution_date between p_effort_start and p_effort_end
4257: AND assignment_id = paf.assignment_id
4258: AND reversal_entry_flag IS NULL
4259: AND rownum=1 )

Line 4294: FROM psp_pre_gen_dist_lines_history ppg

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

Line 4331: FROM psp_pre_gen_dist_lines_history ppg

4327: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
4328: AND pdnh.reversal_entry_flag IS NULL
4329: AND pdnh.adjustment_batch_name IS NULL )
4330: OR EXISTS (SELECT 1
4331: FROM psp_pre_gen_dist_lines_history ppg
4332: WHERE ppg.summary_line_id = psl.summary_line_id
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)

Line 4369: FROM psp_pre_gen_dist_lines_history ppg

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

Line 4405: FROM psp_pre_gen_dist_lines_history ppg

4401: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
4402: AND pdnh.reversal_entry_flag IS NULL
4403: AND pdnh.adjustment_batch_name IS NULL )
4404: OR EXISTS (SELECT 1
4405: FROM psp_pre_gen_dist_lines_history ppg
4406: WHERE ppg.summary_line_id = psl.summary_line_id
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)

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

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

Line 4500: FROM psp_pre_gen_dist_lines_history

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

Line 4536: FROM psp_pre_gen_dist_lines_history

4532: AND paf.effective_end_date >= p_effort_start
4533: AND paf.assignment_status_type_id = past.assignment_status_type_id
4534: AND ( past.per_system_status <> 'TERM_ASSIGN'
4535: OR EXISTS ( select null
4536: FROM psp_pre_gen_dist_lines_history
4537: WHERE distribution_date between p_effort_start and p_effort_end
4538: AND assignment_id = paf.assignment_id
4539: AND reversal_entry_flag IS NULL
4540: 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 4617: FROM psp_pre_gen_dist_lines_history

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

Line 4649: FROM psp_pre_gen_dist_lines_history

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

Line 4681: FROM psp_pre_gen_dist_lines_history

4677: AND paf.effective_end_date >= p_effort_start
4678: AND paf.assignment_status_type_id = past.assignment_status_type_id
4679: AND ( past.per_system_status <> 'TERM_ASSIGN'
4680: OR EXISTS ( select null
4681: FROM psp_pre_gen_dist_lines_history
4682: WHERE distribution_date between p_effort_start and p_effort_end
4683: AND assignment_id = paf.assignment_id
4684: AND reversal_entry_flag IS NULL
4685: AND rownum=1 )

Line 4729: FROM psp_pre_gen_dist_lines_history

4725: WHERE ' || l_sql_string || ')
4726: AND paf.assignment_status_type_id = past.assignment_status_type_id
4727: AND ( past.per_system_status <> ''' ||'TERM_ASSIGN' || '''
4728: OR EXISTS ( select null
4729: FROM psp_pre_gen_dist_lines_history
4730: WHERE distribution_date between :p_effort_start and :p_effort_end
4731: AND assignment_id = paf.assignment_id
4732: AND reversal_entry_flag IS NULL
4733: AND rownum=1 )

Line 4772: psp_pre_gen_dist_lines_history ppg,

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

Line 4950: FROM psp_pre_gen_dist_lines_history ppg

4946: AND p_effort_end
4947: AND pdnh.reversal_entry_flag IS NULL
4948: AND pdnh.adjustment_batch_name IS NULL)
4949: OR EXISTS (SELECT 1
4950: FROM psp_pre_gen_dist_lines_history ppg
4951: WHERE ppg.summary_line_id = psl.summary_line_id
4952: AND ppg.distribution_date BETWEEN p_effort_start
4953: AND p_effort_end
4954: AND ppg.adjustment_batch_name IS NULL

Line 4992: FROM psp_pre_gen_dist_lines_history ppg

4988: AND p_effort_end
4989: AND pdnh.reversal_entry_flag IS NULL
4990: AND pdnh.adjustment_batch_name IS NULL)
4991: OR EXISTS (SELECT 1
4992: FROM psp_pre_gen_dist_lines_history ppg
4993: WHERE ppg.summary_line_id = psl.summary_line_id
4994: AND ppg.distribution_date BETWEEN p_effort_start
4995: AND p_effort_end
4996: AND ppg.adjustment_batch_name IS NULL

Line 5034: FROM psp_pre_gen_dist_lines_history ppg

5030: AND p_effort_end
5031: AND pdnh.reversal_entry_flag IS NULL
5032: AND pdnh.adjustment_batch_name IS NULL)
5033: OR EXISTS (SELECT 1
5034: FROM psp_pre_gen_dist_lines_history ppg
5035: WHERE ppg.summary_line_id = psl.summary_line_id
5036: AND ppg.distribution_date BETWEEN p_effort_start
5037: AND p_effort_end
5038: AND ppg.adjustment_batch_name IS NULL

Line 5075: FROM psp_pre_gen_dist_lines_history ppg

5071: AND p_effort_end
5072: AND pdnh.reversal_entry_flag IS NULL
5073: AND pdnh.adjustment_batch_name IS NULL )
5074: OR EXISTS (SELECT 1
5075: FROM psp_pre_gen_dist_lines_history ppg
5076: WHERE ppg.summary_line_id = psl.summary_line_id
5077: AND ppg.distribution_date BETWEEN p_effort_start
5078: AND p_effort_end
5079: AND ppg.adjustment_batch_name IS NULL

Line 5304: psp_pre_gen_dist_lines_history ppg, gl_code_combinations gcc

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

Line 5455: FROM psp_pre_gen_dist_lines_history ppg

5451: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
5452: AND pdnh.reversal_entry_flag IS NULL
5453: AND pdnh.adjustment_batch_name IS NULL)
5454: OR EXISTS (SELECT 1
5455: FROM psp_pre_gen_dist_lines_history ppg
5456: WHERE ppg.summary_line_id = psl.summary_line_id
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)

Line 5494: FROM psp_pre_gen_dist_lines_history ppg

5490: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
5491: AND pdnh.reversal_entry_flag IS NULL
5492: AND pdnh.adjustment_batch_name IS NULL)
5493: OR EXISTS (SELECT 1
5494: FROM psp_pre_gen_dist_lines_history ppg
5495: WHERE ppg.summary_line_id = psl.summary_line_id
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)

Line 5533: FROM psp_pre_gen_dist_lines_history ppg

5529: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
5530: AND pdnh.reversal_entry_flag IS NULL
5531: AND pdnh.adjustment_batch_name IS NULL)
5532: OR EXISTS (SELECT 1
5533: FROM psp_pre_gen_dist_lines_history ppg
5534: WHERE ppg.summary_line_id = psl.summary_line_id
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)

Line 5571: FROM psp_pre_gen_dist_lines_history ppg

5567: AND pdnh.distribution_date BETWEEN p_effort_start AND p_effort_end
5568: AND pdnh.reversal_entry_flag IS NULL
5569: AND pdnh.adjustment_batch_name IS NULL)
5570: OR EXISTS (SELECT 1
5571: FROM psp_pre_gen_dist_lines_history ppg
5572: WHERE ppg.summary_line_id = psl.summary_line_id
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)

Line 5772: psp_pre_gen_dist_lines_history ppg,

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