APPS.PAY_JP_UITE_ARCH_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 1000: ,p_database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE)

996: AND PTP.start_date <= p_termination_date
997: ORDER BY PTP.start_date DESC;
998: --
999: CURSOR lcu_get_bal_id(p_balance_name pay_balance_types.balance_name%TYPE
1000: ,p_database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE)
1001: IS
1002: SELECT PDB.defined_balance_id
1003: ,PBT.balance_type_id
1004: FROM pay_balance_types PBT

Line 1005: ,pay_balance_dimensions PBD

1001: IS
1002: SELECT PDB.defined_balance_id
1003: ,PBT.balance_type_id
1004: FROM pay_balance_types PBT
1005: ,pay_balance_dimensions PBD
1006: ,pay_defined_balances PDB
1007: WHERE PBT.balance_name = p_balance_name
1008: AND PBD.database_item_suffix = p_database_item_suffix
1009: AND PBT.balance_type_id = PDB.balance_type_id

Line 1800: ,p_database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE)

1796: AND ppa2.action_type = 'V')
1797: ORDER BY paa.action_sequence;
1798: --
1799: CURSOR lcu_get_bal_id(p_balance_name pay_balance_types.balance_name%TYPE
1800: ,p_database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE)
1801: IS
1802: SELECT PDB.defined_balance_id
1803: FROM pay_balance_types PBT
1804: ,pay_balance_dimensions PBD

Line 1804: ,pay_balance_dimensions PBD

1800: ,p_database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE)
1801: IS
1802: SELECT PDB.defined_balance_id
1803: FROM pay_balance_types PBT
1804: ,pay_balance_dimensions PBD
1805: ,pay_defined_balances PDB
1806: WHERE PBT.balance_name = p_balance_name
1807: AND PBD.database_item_suffix = p_database_item_suffix
1808: AND PBT.balance_type_id = PDB.balance_type_id