APPS.PQP_US_PENSION_EXTRACTS dependencies on PER_PEOPLE_EXTRA_INFO

Line 774: FROM per_people_extra_info pei

770:
771: CURSOR csr_pei (c_person_id IN NUMBER
772: ,c_information_type IN VARCHAR2) IS
773: SELECT pei.person_extra_info_id
774: FROM per_people_extra_info pei
775: WHERE pei.person_id = c_person_id
776: AND pei.information_type = c_information_type;
777:
778: CURSOR csr_aei (c_assignment_id IN NUMBER

Line 817: Extra Person Information Extra Person Info DDF PER_PEOPLE_EXTRA_INFO

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:
821: BEGIN

Line 818: Extra Person Info. Details PER_PEOPLE_EXTRA_INFO -DO-

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:
821: BEGIN
822: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 837: 'PER_PEOPLE_EXTRA_INFO') THEN

833: RETURN l_return_value;
834: END IF;
835: CLOSE csr_asg;
836: IF p_flex_name IN('Extra Person Info DDF',
837: 'PER_PEOPLE_EXTRA_INFO') THEN
838: Hr_Utility.set_location('..p_flex_name = '||p_flex_name, 6);
839: OPEN csr_per_mult_occur(c_information_type => p_flex_context);
840: FETCH csr_per_mult_occur INTO l_mult_occur;
841: CLOSE csr_per_mult_occur;

Line 849: l_tab_name := 'PER_PEOPLE_EXTRA_INFO';

845: ,c_information_type => p_flex_context);
846: FETCH csr_pei INTO l_key_val;
847: CLOSE csr_pei;
848: l_key_col := 'PERSON_EXTRA_INFO_ID';
849: l_tab_name := 'PER_PEOPLE_EXTRA_INFO';
850: ELSE
851: Hr_Utility.set_location('..l_mult_occur = '||l_mult_occur, 6);
852: p_error_code := '-20001';
853: p_err_message := 'Contexts :'||p_flex_context ||

Line 904: 'PER_PEOPLE_EXTRA_INFO') THEN

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
908: ,p_flex_context => p_flex_context