APPS.HR_ASSIGNMENT_INTERNAL dependencies on PQP_CONFIGURATION_VALUES

Line 6773: l_business_group_id pqp_configuration_values.business_group_id%TYPE;

6769:
6770: procedure auto_calc_fte (p_assignment_id in number,
6771: p_effective_start_date in Date)
6772: IS
6773: l_business_group_id pqp_configuration_values.business_group_id%TYPE;
6774: l_legislation_code pqp_configuration_values.legislation_code%TYPE;
6775: l_abv_uom pqp_configuration_values.pcv_information1%TYPE;
6776: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
6777: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

Line 6774: l_legislation_code pqp_configuration_values.legislation_code%TYPE;

6770: procedure auto_calc_fte (p_assignment_id in number,
6771: p_effective_start_date in Date)
6772: IS
6773: l_business_group_id pqp_configuration_values.business_group_id%TYPE;
6774: l_legislation_code pqp_configuration_values.legislation_code%TYPE;
6775: l_abv_uom pqp_configuration_values.pcv_information1%TYPE;
6776: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
6777: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
6778: l_assignment_type varchar2(30);

Line 6775: l_abv_uom pqp_configuration_values.pcv_information1%TYPE;

6771: p_effective_start_date in Date)
6772: IS
6773: l_business_group_id pqp_configuration_values.business_group_id%TYPE;
6774: l_legislation_code pqp_configuration_values.legislation_code%TYPE;
6775: l_abv_uom pqp_configuration_values.pcv_information1%TYPE;
6776: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
6777: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
6778: l_assignment_type varchar2(30);
6779:

Line 6804: FROM pqp_configuration_values mtn

6800: ,def.configuration_name defn_config_name
6801: ,def.business_group_id defn_bg_id
6802: ,def.legislation_code defn_leg_code
6803: ,def.pcv_information4 defn_custom_function
6804: FROM pqp_configuration_values mtn
6805: ,pqp_configuration_values def
6806: WHERE mtn.pcv_information_category = 'PQP_ABVM_MAINTENANCE'
6807: AND def.pcv_information_category = 'PQP_ABVM_DEFINITION'
6808: AND def.pcv_information1 = mtn.pcv_information1

Line 6805: ,pqp_configuration_values def

6801: ,def.business_group_id defn_bg_id
6802: ,def.legislation_code defn_leg_code
6803: ,def.pcv_information4 defn_custom_function
6804: FROM pqp_configuration_values mtn
6805: ,pqp_configuration_values def
6806: WHERE mtn.pcv_information_category = 'PQP_ABVM_MAINTENANCE'
6807: AND def.pcv_information_category = 'PQP_ABVM_DEFINITION'
6808: AND def.pcv_information1 = mtn.pcv_information1
6809: AND mtn.pcv_information2 = 'Y'

Line 6816: FROM pqp_configuration_values bgmtn

6812: ( ( mtn.business_group_id IS NULL AND mtn.legislation_code = p_legislation_code )
6813: AND -- there does not exist a config for this UOM at bg level
6814: NOT EXISTS
6815: (SELECT 1
6816: FROM pqp_configuration_values bgmtn
6817: WHERE bgmtn.pcv_information_category = 'PQP_ABVM_MAINTENANCE'
6818: AND bgmtn.pcv_information1 = mtn.pcv_information1
6819: AND bgmtn.business_group_id = p_business_group_id
6820: ) -- NOT EXISTS

Line 6827: FROM pqp_configuration_values hlmtn

6823: ( ( mtn.business_group_id IS NULL AND mtn.legislation_code IS NULL )
6824: AND -- there does not exist a config for this UOM at a higher level
6825: NOT EXISTS
6826: (SELECT 1
6827: FROM pqp_configuration_values hlmtn
6828: WHERE hlmtn.pcv_information_category = 'PQP_ABVM_MAINTENANCE'
6829: AND hlmtn.pcv_information1 = mtn.pcv_information1
6830: AND ( hlmtn.business_group_id = p_business_group_id
6831: OR