APPS.PAY_EEI_BUS dependencies on PAY_INPUT_VALUES_F

Line 545: from pay_input_values_f paf

541: l_business_group_id pay_rates.business_group_id%type ;
542:
543: cursor c_input_value is
544: select 'Y'
545: from pay_input_values_f paf
546: where element_type_id = p_element_type_id
547: and upper(name) = upper(p_qualifier)
548: and (( paf.business_group_id is not null
549: and paf.business_group_id = nvl(l_business_group_id,paf.business_group_id))

Line 776: FROM PAY_INPUT_VALUES_F

772: l_proc varchar2(72) := g_package||'chk_input_value';
773: l_exists varchar2(1) ;
774: CURSOR c_input_value IS
775: SELECT 'Y'
776: FROM PAY_INPUT_VALUES_F
777: WHERE element_type_id = p_element_type_id
778: AND UPPER(name) = UPPER(p_input_value) ;
779: begin
780:

Line 844: FROM PAY_INPUT_VALUES_F

840: and pur.effective_end_date;
841:
842: CURSOR c_input_value(p_input_value varchar2) IS
843: SELECT 'Y'
844: FROM PAY_INPUT_VALUES_F
845: WHERE element_type_id = p_element_type_id
846: AND UPPER(name) = UPPER(p_input_value) ;
847:
848: l_exists varchar2(1);

Line 1208: ,pay_input_values_f piv

1204: CURSOR is_ele_spread_bonus
1205: IS
1206: SELECT 1
1207: FROM pay_element_types_f pet
1208: ,pay_input_values_f piv
1209: WHERE piv.element_type_id = pet.element_type_id
1210: AND pet.element_type_id = p_element_type_id
1211: AND (pet.processing_type = 'N'
1212: AND UPPER(piv.NAME) = UPPER('CLAIM DATE'))

Line 1251: l_uom pay_input_values_f.uom%TYPE;

1247: l_proc varchar2(72) := g_package||'chk_valid_bonus_elements';
1248:
1249: l_element_name pay_element_types_f.element_name%TYPE;
1250: l_processing_type pay_element_types_f.processing_type%TYPE;
1251: l_uom pay_input_values_f.uom%TYPE;
1252:
1253: CURSOR csr_get_element_info
1254: IS
1255: SELECT pet.element_name

Line 1259: pay_input_values_f piv

1255: SELECT pet.element_name
1256: ,pet.processing_type
1257: ,piv.uom
1258: FROM pay_element_types_f pet,
1259: pay_input_values_f piv
1260: WHERE pet.element_type_id = p_element_type_id
1261: AND pet.element_type_id = piv.element_type_id (+)
1262: AND upper(piv.NAME (+)) = 'CLAIM DATE';
1263: