APPS.PAY_PBF_BUS dependencies on PAY_BALANCE_TYPES

Line 686: from pay_balance_types

682: l_legislation_code per_business_groups.legislation_code%type;
683:
684: cursor csr_bal_type_id is
685: select '1'
686: from pay_balance_types
687: where balance_type_id = p_balance_type_id
688: and nvl(legislation_code, nvl(l_legislation_code, hr_api.g_varchar2))
689: = nvl(l_legislation_code, hr_api.g_varchar2)
690: and nvl(business_group_id, nvl(p_business_group_id, hr_api.g_number))

Line 895: FROM pay_balance_types pbt

891: l_proc varchar2(72) := g_package||'chk_uom';
892:
893: CURSOR csr_bal_uom IS
894: SELECT pbt.balance_uom
895: FROM pay_balance_types pbt
896: WHERE pbt.balance_type_id = p_balance_type_id;
897: --
898: CURSOR csr_ipv_uom IS
899: SELECT piv.uom

Line 957: FROM pay_balance_types

953: l_proc varchar2(72) := g_package||'chk_currency_match';
954:
955: CURSOR csr_balance_uom IS
956: SELECT balance_uom
957: FROM pay_balance_types
958: WHERE balance_type_id = p_balance_type_id;
959:
960: CURSOR csr_currency_match IS
961: SELECT 1

Line 962: FROM pay_balance_types pbt,

958: WHERE balance_type_id = p_balance_type_id;
959:
960: CURSOR csr_currency_match IS
961: SELECT 1
962: FROM pay_balance_types pbt,
963: pay_input_values_f piv,
964: pay_element_types_f pet
965: WHERE pbt.balance_type_id = p_balance_type_id
966: AND piv.input_value_id = p_input_value_id