DBA Data[Home] [Help]

APPS.PAY_US_BALANCE_FEEDS_HOOK dependencies on PAY_BALANCE_DIMENSIONS

Line 72: from pay_balance_dimensions pbd

68: )
69: and exists
70: (
71: select 1
72: from pay_balance_dimensions pbd
73: where pbd.balance_dimension_id = pdb.balance_dimension_id
74: /*Dimension names are used in place of database_item_suffix to utilize
75: PAY_BALANCE_DIMENSIONS_UK2 index*/
76: and pbd.dimension_name in ('Assignment Within GRE Time Definition Run'

Line 75: PAY_BALANCE_DIMENSIONS_UK2 index*/

71: select 1
72: from pay_balance_dimensions pbd
73: where pbd.balance_dimension_id = pdb.balance_dimension_id
74: /*Dimension names are used in place of database_item_suffix to utilize
75: PAY_BALANCE_DIMENSIONS_UK2 index*/
76: and pbd.dimension_name in ('Assignment Within GRE Time Definition Run'
77: ,'Assignment Within GRE Time Definition BD Run')
78: and pbd.legislation_code = 'US' -- Seeded Dimensions
79: and pbd.business_group_id IS NULL