DBA Data[Home] [Help]

APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on PAY_BALANCE_TYPES

Line 2694: FROM pay_balance_types pbt

2690: IS
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';

Line 2712: FROM pay_balance_types pbt

2708:
2709: CURSOR c_get_gross_pay_bal_name
2710: IS
2711: SELECT balance_type_id
2712: FROM pay_balance_types pbt
2713: WHERE balance_name = 'Gross Pay'
2714: AND pbt.legislation_code='GB' ;
2715:
2716:

Line 2851: FROM pay_balance_types pbt

2847:
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';