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 873: FROM pay_balance_types pbt

869: l_proc varchar2(72) := g_package||'chk_uom';
870:
871: CURSOR csr_bal_uom IS
872: SELECT pbt.balance_uom
873: FROM pay_balance_types pbt
874: WHERE pbt.balance_type_id = p_balance_type_id;
875: --
876: CURSOR csr_ipv_uom IS
877: SELECT piv.uom

Line 935: FROM pay_balance_types

931: l_proc varchar2(72) := g_package||'chk_currency_match';
932:
933: CURSOR csr_balance_uom IS
934: SELECT balance_uom
935: FROM pay_balance_types
936: WHERE balance_type_id = p_balance_type_id;
937:
938: CURSOR csr_currency_match IS
939: SELECT 1

Line 940: FROM pay_balance_types pbt,

936: WHERE balance_type_id = p_balance_type_id;
937:
938: CURSOR csr_currency_match IS
939: SELECT 1
940: FROM pay_balance_types pbt,
941: pay_input_values_f piv,
942: pay_element_types_f pet
943: WHERE pbt.balance_type_id = p_balance_type_id
944: AND piv.input_value_id = p_input_value_id