DBA Data[Home] [Help]

APPS.PA_ACCUM_API dependencies on DUAL

Line 474: SYS.DUAL */

470: UNION
471: SELECT -- Group level Resource list member
472: X_RESOURCE_LIST_MEMBER_ID
473: FROM
474: SYS.DUAL */
475: )
476: )
477: AND EXISTS
478: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

Line 559: SYS.DUAL */

555: UNION
556: SELECT -- Group level Resource list member
557: X_RESOURCE_LIST_MEMBER_ID
558: FROM
559: SYS.DUAL */
560: )
561: )
562: AND EXISTS
563: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

Line 948: SYS.DUAL

944: UNION
945: SELECT -- Group level Resource list member
946: x_resource_list_member_id
947: FROM
948: SYS.DUAL
949: )
950: AND x_period_type = 'P'
951: AND pp.period_name = bpv.pa_period
952: AND pp.start_date BETWEEN

Line 998: SYS.DUAL

994: UNION
995: SELECT -- Group level Resource list member
996: x_resource_list_member_id
997: FROM
998: SYS.DUAL
999: )
1000: AND x_period_type = 'G'
1001: AND glp.period_name = bpv.gl_period_name
1002: AND glp.set_of_books_id = imp.set_of_books_id