APPS.PAY_PEL_BUS dependencies on PAY_INPUT_VALUES_F

Line 682: from pay_input_values_f

678: effective_end_date,
679: input_value_id,
680: default_value,max_value,
681: min_value,warning_or_error
682: from pay_input_values_f
683: where element_type_id = p_element_type_id
684: and p_effective_date between effective_start_date and effective_end_date;
685:
686: l_link_input_value_id number;

Line 1322: l_uom pay_input_values_f.UOM%TYPE;

1318: ) is
1319: --
1320: l_proc varchar2(72) := g_package || 'chk_costable_type';
1321: l_costable_flag pay_element_classifications.costable_flag%TYPE;
1322: l_uom pay_input_values_f.UOM%TYPE;
1323:
1324: l_leg_code per_business_groups.legislation_code%TYPE;
1325: l_costing_dc pay_element_classifications.costing_debit_or_credit%TYPE;
1326:

Line 1339: from pay_input_values_f

1335: and effective_end_date);
1336:
1337: cursor csr_PayValue is
1338: select UOM
1339: from pay_input_values_f
1340: where element_type_id = p_element_type_id
1341: and upper(name) like 'PAY VALUE'
1342: and p_effective_date between effective_start_date and effective_end_date;
1343:

Line 1580: pay_input_values_f piv

1576:
1577: cursor csr_pay_basis_exists is
1578: select 1
1579: from
1580: pay_input_values_f piv
1581: ,per_pay_bases ppb
1582: where
1583: piv.element_type_id = p_element_type_id
1584: and p_effective_date between piv.effective_start_date