APPS.HRDYNDBI dependencies on PAY_DIMENSION_ROUTES

Line 1055: from pay_dimension_routes pdr

1051: select pdr.route_id,
1052: pdr.route_type,
1053: pdr.run_dimension_id,
1054: pdr.priority
1055: from pay_dimension_routes pdr
1056: where pdr.balance_dimension_id = p_bal_dim
1057: and not exists (select null
1058: from ff_user_entities u
1059: where u.creator_id = p_defined_balance_id

Line 1546: from pay_dimension_routes pdr

1542: where b.defined_balance_id = u.creator_id
1543: and u.creator_type = 'RB')
1544: and exists
1545: (select null
1546: from pay_dimension_routes pdr
1547: where pdr.balance_dimension_id = b.balance_dimension_id)
1548: )
1549: OR /* def bal ue does exists but has a missing ue pdr */
1550: (

Line 1553: from pay_dimension_routes pdr

1549: OR /* def bal ue does exists but has a missing ue pdr */
1550: (
1551: exists (
1552: select pdr.balance_dimension_id
1553: from pay_dimension_routes pdr
1554: where pdr.balance_dimension_id = b.balance_dimension_id
1555: and not exists (select null
1556: from ff_user_entities ue
1557: where ue.creator_id = b.defined_balance_id

Line 1722: from pay_dimension_routes pdr

1718: where a.defined_balance_id = u.creator_id
1719: and u.creator_type = 'RB')
1720: and exists
1721: (select null
1722: from pay_dimension_routes pdr
1723: where pdr.balance_dimension_id = a.balance_dimension_id)
1724: )
1725: OR /* def bal ue does exists but has a missing ue pdr */
1726: (

Line 1729: from pay_dimension_routes pdr

1725: OR /* def bal ue does exists but has a missing ue pdr */
1726: (
1727: exists (
1728: select pdr.balance_dimension_id
1729: from pay_dimension_routes pdr
1730: where pdr.balance_dimension_id = a.balance_dimension_id
1731: and not exists (select null
1732: from ff_user_entities ue
1733: where ue.creator_id = a.defined_balance_id

Line 5522: from pay_dimension_routes pdr

5518: where b.defined_balance_id = ent.creator_id
5519: and ent.creator_type = 'RB'
5520: and exists
5521: (select null
5522: from pay_dimension_routes pdr
5523: where pdr.balance_dimension_id = b.balance_dimension_id)
5524: )
5525: OR
5526: (exists (

Line 5528: from pay_dimension_routes pdr,

5524: )
5525: OR
5526: (exists (
5527: select pdr.balance_dimension_id
5528: from pay_dimension_routes pdr,
5529: pay_defined_balances b
5530: where pdr.balance_dimension_id = b.balance_dimension_id
5531: and not exists (select null
5532: from ff_user_entities ue