APPS.HRDYNDBI dependencies on PAY_DIMENSION_ROUTES

Line 1058: from pay_dimension_routes pdr

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

Line 1549: from pay_dimension_routes pdr

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

Line 1556: from pay_dimension_routes pdr

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

Line 1725: from pay_dimension_routes pdr

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

Line 1732: from pay_dimension_routes pdr

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

Line 5525: from pay_dimension_routes pdr

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

Line 5531: from pay_dimension_routes pdr,

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