APPS.PQP_US_PENSION_EXTRACTS dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 781: FROM per_assignment_extra_info aei

777:
778: CURSOR csr_aei (c_assignment_id IN NUMBER
779: ,c_information_type IN VARCHAR2) IS
780: SELECT aei.assignment_extra_info_id
781: FROM per_assignment_extra_info aei
782: WHERE aei.assignment_id = c_assignment_id
783: AND aei.information_type = c_information_type;
784:
785: CURSOR csr_asg_mult_occur(c_information_type IN VARCHAR2) IS

Line 815: Extra Assignment Information Assignment Developer DF PER_ASSIGNMENT_EXTRA_INFO

811: /*
812: +============================+=========================+=========================+
813: |DDF/DF Title | p_flex_name |TABLE |
814: +============================+=========================+=========================+
815: Extra Assignment Information Assignment Developer DF PER_ASSIGNMENT_EXTRA_INFO
816: Assignment Extra Information PER_ASSIGNMENT_EXTRA_INFO -DO-
817: Extra Person Information Extra Person Info DDF PER_PEOPLE_EXTRA_INFO
818: Extra Person Info. Details PER_PEOPLE_EXTRA_INFO -DO-
819: */

Line 816: Assignment Extra Information PER_ASSIGNMENT_EXTRA_INFO -DO-

812: +============================+=========================+=========================+
813: |DDF/DF Title | p_flex_name |TABLE |
814: +============================+=========================+=========================+
815: Extra Assignment Information Assignment Developer DF PER_ASSIGNMENT_EXTRA_INFO
816: Assignment Extra Information PER_ASSIGNMENT_EXTRA_INFO -DO-
817: Extra Person Information Extra Person Info DDF PER_PEOPLE_EXTRA_INFO
818: Extra Person Info. Details PER_PEOPLE_EXTRA_INFO -DO-
819: */
820:

Line 859: 'PER_ASSIGNMENT_EXTRA_INFO') THEN

855: l_return_value := 'EXT_ERR_WARNING';
856: RETURN l_return_value;
857: END IF;
858: ELSIF p_flex_name IN('Assignment Developer DF',
859: 'PER_ASSIGNMENT_EXTRA_INFO') THEN
860: Hr_Utility.set_location('..p_flex_name = '||p_flex_name, 7);
861: OPEN csr_asg_mult_occur(c_information_type => p_flex_context);
862: FETCH csr_asg_mult_occur INTO l_mult_occur;
863: CLOSE csr_asg_mult_occur;

Line 871: l_tab_name := 'PER_ASSIGNMENT_EXTRA_INFO';

867: ,c_information_type => p_flex_context);
868: FETCH csr_aei INTO l_key_val;
869: CLOSE csr_aei;
870: l_key_col := 'ASSIGNMENT_EXTRA_INFO_ID';
871: l_tab_name := 'PER_ASSIGNMENT_EXTRA_INFO';
872: ELSE
873: Hr_Utility.set_location('..l_mult_occur = '||l_mult_occur, 7);
874: p_error_code := '-20001';
875: p_err_message := 'Contexts :'||p_flex_context ||

Line 903: ELSIF p_flex_name IN ('PER_ASSIGNMENT_EXTRA_INFO',

899: ,p_message => p_err_message
900: );
901: l_return_value := l_ddf_seg_value;
902: Hr_Utility.set_location('..get_ddf_value ='||l_return_value, 10);
903: ELSIF p_flex_name IN ('PER_ASSIGNMENT_EXTRA_INFO',
904: 'PER_PEOPLE_EXTRA_INFO') THEN
905: Hr_Utility.set_location('..Calling pqp_utilities.get_df_value', 9);
906: l_df_seg_value:= Pqp_Utilities.get_df_value(
907: p_flex_name => p_flex_name

Line 933: 'Extra Person Info DDF,PER_ASSIGNMENT_EXTRA_INFO,PER_ASSIGNMENT_EXTRA_INFO';

929: EXCEPTION
930: WHEN Invaild_DDF_or_DF THEN
931: p_error_code := '-20001';
932: p_err_message := 'Currently Supported DDF/DFs :Assignment Developer DF,'||
933: 'Extra Person Info DDF,PER_ASSIGNMENT_EXTRA_INFO,PER_ASSIGNMENT_EXTRA_INFO';
934: l_return_value := 'EXT_ERR_WARNING';
935: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
936: RETURN l_return_value;
937:

Line 1145: FROM per_assignment_extra_info pae

1141:
1142: CURSOR csr_asg_ppg (c_effective_date IN DATE
1143: ,c_assignment_id IN NUMBER ) IS
1144: SELECT pae.aei_information1 -- PPG Code
1145: FROM per_assignment_extra_info pae
1146: WHERE pae.assignment_id = c_assignment_id
1147: AND pae.information_type = 'PQP_US_TIAA_CREF_CODES';
1148:
1149: CURSOR csr_pay_ppg (c_effective_date IN DATE