DBA Data[Home] [Help]

APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 2695: ,pay_balance_dimensions pbd

2691: CURSOR c_get_balance_name
2692: IS
2693: SELECT balance_type_id ,pbd.balance_dimension_id
2694: FROM pay_balance_types pbt
2695: ,pay_balance_dimensions pbd
2696: WHERE balance_name = p_element_name||' Processed Amt'
2697: AND pbd.legislation_code='GB'
2698: AND pbd.dimension_name='_ELEMENT_ITD';
2699:

Line 2852: ,pay_balance_dimensions pbd

2848: CURSOR c_get_balance_name
2849: IS
2850: SELECT balance_type_id ,pbd.balance_dimension_id
2851: FROM pay_balance_types pbt
2852: ,pay_balance_dimensions pbd
2853: WHERE balance_name = p_element_name||' Processed Amt'
2854: AND pbd.legislation_code='GB'
2855: AND pbd.dimension_name='_ELEMENT_ITD';
2856: