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 825: pay_input_values_f inv,

821:
822: CURSOR csr_initial_feed_exist IS
823: SELECT 1
824: FROM pay_balance_feeds_f blf,
825: pay_input_values_f inv,
826: pay_element_types_f elt,
827: pay_element_classifications ec
828: WHERE blf.balance_type_id = p_balance_type_id
829: AND blf.input_value_id = inv.input_value_id

Line 900: FROM pay_input_values_f piv

896: WHERE pbt.balance_type_id = p_balance_type_id;
897: --
898: CURSOR csr_ipv_uom IS
899: SELECT piv.uom
900: FROM pay_input_values_f piv
901: WHERE piv.input_value_id = p_input_value_id
902: AND p_effective_date between piv.effective_start_date
903: AND piv.effective_end_date;
904: --

Line 963: pay_input_values_f piv,

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

Line 1153: FROM pay_input_values_f

1149: l_proc varchar2(72) := g_package||'chk_feed_ipv_life';
1150:
1151: CURSOR csr_feed_ipv_value IS
1152: SELECT 1
1153: FROM pay_input_values_f
1154: WHERE input_value_id = p_input_value_id
1155: AND p_effective_date between effective_start_date and effective_end_date;
1156: --
1157: l_exists number;

Line 1684: FROM pay_input_values_f inv,

1680: -- Declare cursor
1681: --
1682: cursor csr_balance_init_flag is
1683: SELECT 1
1684: FROM pay_input_values_f inv,
1685: pay_element_types_f elt,
1686: pay_element_classifications ec
1687: WHERE inv.input_value_id = p_input_value_id
1688: AND inv.element_type_id = elt.element_type_id

Line 1736: FROM pay_input_values_f inv

1732: -- Declare cursor
1733: --
1734: cursor csr_is_pay_value is
1735: SELECT 1
1736: FROM pay_input_values_f inv
1737: WHERE inv.input_value_id = p_input_value_id
1738: AND inv.name = 'Pay Value';
1739: --
1740: -- Declare local variables