APPS.PA_TXN_ACCUMS dependencies on PA_PERIODS

Line 488: FROM pa_periods

484: AND ptad.line_type = 'C'
485: )
486: AND EXISTS
487: ( SELECT 'Yes'
488: FROM pa_periods
489: WHERE period_name = pta.pa_period
490: AND start_date >= x_start_pa_date
491: AND end_date <= x_end_pa_date
492: );

Line 552: FROM pa_periods

548: AND ptad.line_type IN ('R','E')
549: )
550: AND EXISTS
551: ( SELECT 'Yes'
552: FROM pa_periods
553: WHERE period_name = pta.pa_period
554: AND start_date >= x_start_pa_date
555: AND end_date <= x_end_pa_date
556: );

Line 617: FROM pa_periods

613: AND ptad.line_type = 'M'
614: )
615: AND EXISTS
616: ( SELECT 'Yes'
617: FROM pa_periods
618: WHERE period_name = pta.pa_period
619: AND start_date >= x_start_pa_date
620: AND end_date <= x_end_pa_date
621: );

Line 759: FROM pa_periods

755: AND pta.system_linkage_function =
756: NVL(x_system_linkage_function,pta.system_linkage_function)
757: AND EXISTS
758: ( SELECT 'Yes'
759: FROM pa_periods
760: WHERE period_name = pta.pa_period
761: AND start_date >= x_start_pa_date
762: AND end_date <= x_end_pa_date
763: )

Line 827: FROM pa_periods

823: WHERE
824: pta.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id Commented for bug 3736097
825: AND EXISTS
826: ( SELECT 'Yes'
827: FROM pa_periods
828: WHERE period_name = pta.pa_period
829: AND start_date >= x_start_pa_date
830: AND end_date <= x_end_pa_date
831: )

Line 899: FROM pa_periods

895: AND NVL(pta.system_linkage_function,'X') =
896: NVL(NVL(x_system_linkage_function,pta.system_linkage_function),'X')
897: AND EXISTS
898: ( SELECT 'Yes'
899: FROM pa_periods
900: WHERE period_name = pta.pa_period
901: AND start_date >= x_start_pa_date
902: AND end_date <= x_end_pa_date
903: )

Line 1263: FROM pa_periods

1259: AND NVL(pct.system_linkage_function,'X') =
1260: NVL(NVL(x_system_linkage_function,pct.system_linkage_function),'X')
1261: AND EXISTS
1262: ( SELECT 'Yes'
1263: FROM pa_periods
1264: WHERE period_name = pct.pa_period
1265: AND start_date >= x_start_pa_date
1266: AND end_date <= x_end_pa_date
1267: )

Line 1385: PA_PERIODS_ALL per

1381: l_cur_pa_period,
1382: l_cur_gl_period
1383: from
1384: PA_PROJECTS_ALL prj,
1385: PA_PERIODS_ALL per
1386: where
1387: prj.PROJECT_ID = x_start_project_id and
1388: nvl(per.ORG_ID, -1) = nvl(prj.ORG_ID, -1) and
1389: per.CURRENT_PA_PERIOD_FLAG = 'Y';