APPS.PQP_HRTCA_INTEGRATION dependencies on PQP_CONFIGURATION_VALUES

Line 46: FROM pqp_configuration_values pcv

42: CURSOR csr_TCA_Map (c_info_category IN Varchar2
43: ,c_bg_grp_id IN Number
44: ,c_bg_grp_leg_code IN Varchar2) IS
45: SELECT *
46: FROM pqp_configuration_values pcv
47: WHERE pcv.pcv_information_category = c_info_category
48: AND ((pcv.business_group_id = c_bg_grp_id) OR
49: (pcv.legislation_code = c_bg_grp_leg_code AND
50: pcv.business_group_id IS NULL) OR

Line 2859: l_Address_Mapping pqp_configuration_values%ROWTYPE;

2855: TYPE t_Phones IS TABLE OF hz_contact_points.phone_number%TYPE
2856: INDEX BY Binary_Integer;
2857: l_phone_rec t_Phones;
2858: l_phone_no hz_contact_points.phone_number%TYPE;
2859: l_Address_Mapping pqp_configuration_values%ROWTYPE;
2860: l_LookUp_Mapping pqp_configuration_values%ROWTYPE;
2861: ph_count Number(5);
2862:
2863: BEGIN

Line 2860: l_LookUp_Mapping pqp_configuration_values%ROWTYPE;

2856: INDEX BY Binary_Integer;
2857: l_phone_rec t_Phones;
2858: l_phone_no hz_contact_points.phone_number%TYPE;
2859: l_Address_Mapping pqp_configuration_values%ROWTYPE;
2860: l_LookUp_Mapping pqp_configuration_values%ROWTYPE;
2861: ph_count Number(5);
2862:
2863: BEGIN
2864: FOR i IN 1..3 LOOP

Line 2903: -- Get column Lookup mapping record from pqp_configuration_values table

2899:
2900: FETCH csr_TCA_Map INTO l_Address_Mapping;
2901: CLOSE csr_TCA_Map;
2902:
2903: -- Get column Lookup mapping record from pqp_configuration_values table
2904: OPEN csr_TCA_Map (c_info_category => p_lookup_map
2905: ,c_bg_grp_id => p_HR_Address_Rec.business_group_id
2906: ,c_bg_grp_leg_code => p_HR_Address_Rec.Style);
2907:

Line 3477: l_Address_Mapping pqp_configuration_values%ROWTYPE;

3473: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'Create_Address_HR_To_TCA';
3474: l_HZ_Location_Row Hz_Locations%ROWTYPE;
3475: l_HR_Address_Rec Per_addresses%ROWTYPE;
3476: l_address_style per_addresses.style%TYPE;
3477: l_Address_Mapping pqp_configuration_values%ROWTYPE;
3478: l_LookUp_Mapping pqp_configuration_values%ROWTYPE;
3479: l_add_map Varchar2(150);
3480: l_lookup_map Varchar2(150);
3481: l_leg_code Varchar2(5);

Line 3478: l_LookUp_Mapping pqp_configuration_values%ROWTYPE;

3474: l_HZ_Location_Row Hz_Locations%ROWTYPE;
3475: l_HR_Address_Rec Per_addresses%ROWTYPE;
3476: l_address_style per_addresses.style%TYPE;
3477: l_Address_Mapping pqp_configuration_values%ROWTYPE;
3478: l_LookUp_Mapping pqp_configuration_values%ROWTYPE;
3479: l_add_map Varchar2(150);
3480: l_lookup_map Varchar2(150);
3481: l_leg_code Varchar2(5);
3482:

Line 3802: l_Address_Mapping pqp_configuration_values%ROWTYPE;

3798: l_HZ_Location_Row Hz_Locations%ROWTYPE;
3799: l_HZ_Location_Cur_Row Hz_Locations%ROWTYPE;
3800: l_HR_Address_Rec Per_addresses%ROWTYPE;
3801: l_address_style per_addresses.style%TYPE;
3802: l_Address_Mapping pqp_configuration_values%ROWTYPE;
3803: l_LookUp_Mapping pqp_configuration_values%ROWTYPE;
3804: --
3805: l_add_map Varchar2(150);
3806: l_lookup_map Varchar2(150);

Line 3803: l_LookUp_Mapping pqp_configuration_values%ROWTYPE;

3799: l_HZ_Location_Cur_Row Hz_Locations%ROWTYPE;
3800: l_HR_Address_Rec Per_addresses%ROWTYPE;
3801: l_address_style per_addresses.style%TYPE;
3802: l_Address_Mapping pqp_configuration_values%ROWTYPE;
3803: l_LookUp_Mapping pqp_configuration_values%ROWTYPE;
3804: --
3805: l_add_map Varchar2(150);
3806: l_lookup_map Varchar2(150);
3807: l_leg_code Varchar2(5);