DBA Data[Home] [Help]

APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on PAY_BALANCE_TYPES

Line 2708: FROM pay_balance_types pbt

2704: IS
2705: CURSOR c_get_balance_name
2706: IS
2707: SELECT balance_type_id ,pbd.balance_dimension_id
2708: FROM pay_balance_types pbt
2709: ,pay_balance_dimensions pbd
2710: WHERE balance_name = p_element_name||' Processed Amt'
2711: AND pbd.legislation_code='GB'
2712: AND pbd.dimension_name='_ELEMENT_ITD'

Line 2727: FROM pay_balance_types pbt

2723:
2724: CURSOR c_get_gross_pay_bal_name
2725: IS
2726: SELECT balance_type_id
2727: FROM pay_balance_types pbt
2728: WHERE balance_name = 'Gross Pay'
2729: AND pbt.legislation_code='GB' ;
2730:
2731:

Line 2866: FROM pay_balance_types pbt

2862:
2863: CURSOR c_get_balance_name
2864: IS
2865: SELECT balance_type_id ,pbd.balance_dimension_id
2866: FROM pay_balance_types pbt
2867: ,pay_balance_dimensions pbd
2868: WHERE balance_name = p_element_name||' Processed Amt'
2869: AND pbd.legislation_code='GB'
2870: AND pbd.dimension_name='_ELEMENT_ITD';