APPS.PAY_PBF_BUS dependencies on PAY_INPUT_VALUES_F

Line 608: from pay_input_values_f

604: l_legislation_code per_business_groups.legislation_code%type;
605:
606: cursor csr_ipv_id is
607: select '1'
608: from pay_input_values_f
609: where input_value_id = p_input_value_id
610: and nvl(legislation_code, nvl(l_legislation_code, hr_api.g_varchar2))
611: = nvl(l_legislation_code, hr_api.g_varchar2)
612: and nvl(business_group_id, nvl(p_business_group_id, hr_api.g_number))

Line 803: pay_input_values_f inv,

799:
800: CURSOR csr_initial_feed_exist IS
801: SELECT 1
802: FROM pay_balance_feeds_f blf,
803: pay_input_values_f inv,
804: pay_element_types_f elt,
805: pay_element_classifications ec
806: WHERE blf.balance_type_id = p_balance_type_id
807: AND blf.input_value_id = inv.input_value_id

Line 878: FROM pay_input_values_f piv

874: WHERE pbt.balance_type_id = p_balance_type_id;
875: --
876: CURSOR csr_ipv_uom IS
877: SELECT piv.uom
878: FROM pay_input_values_f piv
879: WHERE piv.input_value_id = p_input_value_id
880: AND p_effective_date between piv.effective_start_date
881: AND piv.effective_end_date;
882: --

Line 941: pay_input_values_f piv,

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
945: AND pet.element_type_id = piv.element_type_id

Line 1131: FROM pay_input_values_f

1127: l_proc varchar2(72) := g_package||'chk_feed_ipv_life';
1128:
1129: CURSOR csr_feed_ipv_value IS
1130: SELECT 1
1131: FROM pay_input_values_f
1132: WHERE input_value_id = p_input_value_id
1133: AND p_effective_date between effective_start_date and effective_end_date;
1134: --
1135: l_exists number;

Line 1641: FROM pay_input_values_f inv,

1637: -- Declare cursor
1638: --
1639: cursor csr_balance_init_flag is
1640: SELECT 1
1641: FROM pay_input_values_f inv,
1642: pay_element_types_f elt,
1643: pay_element_classifications ec
1644: WHERE inv.input_value_id = p_input_value_id
1645: AND inv.element_type_id = elt.element_type_id