APPS.PQP_PENSION_EXTRACTS dependencies on PER_PEOPLE_EXTRA_INFO

Line 2789: FROM per_people_extra_info pei

2785:
2786: CURSOR csr_pei (c_person_id IN NUMBER
2787: ,c_information_type IN VARCHAR2) IS
2788: SELECT pei.person_extra_info_id
2789: FROM per_people_extra_info pei
2790: WHERE pei.person_id = c_person_id
2791: AND pei.information_type = c_information_type;
2792:
2793: CURSOR csr_aei (c_assignment_id IN NUMBER

Line 2868: |Extra Person Information |Extra Person Info DDF |PER_PEOPLE_EXTRA_INFO |

2864: |DDF/DF Title | p_flex_name |TABLE |
2865: +=============================+=========================+============================+
2866: |Extra Assignment Information |Assignment Developer DF |PER_ASSIGNMENT_EXTRA_INFO |
2867: |Assignment Extra Information |PER_ASSIGNMENT_EXTRA_INFO| -DO- |
2868: |Extra Person Information |Extra Person Info DDF |PER_PEOPLE_EXTRA_INFO |
2869: |Extra Person Info. Details |PER_PEOPLE_EXTRA_INFO | -DO- |
2870: |Org Developer DF |Org Developer DF |HR_ORGANIZATION_INFORMATION |
2871: |Further Person Information |Person Developer DF |PER_ALL_PEOPLE_F |
2872: | | | |

Line 2869: |Extra Person Info. Details |PER_PEOPLE_EXTRA_INFO | -DO- |

2865: +=============================+=========================+============================+
2866: |Extra Assignment Information |Assignment Developer DF |PER_ASSIGNMENT_EXTRA_INFO |
2867: |Assignment Extra Information |PER_ASSIGNMENT_EXTRA_INFO| -DO- |
2868: |Extra Person Information |Extra Person Info DDF |PER_PEOPLE_EXTRA_INFO |
2869: |Extra Person Info. Details |PER_PEOPLE_EXTRA_INFO | -DO- |
2870: |Org Developer DF |Org Developer DF |HR_ORGANIZATION_INFORMATION |
2871: |Further Person Information |Person Developer DF |PER_ALL_PEOPLE_F |
2872: | | | |
2873: +=============================+=========================+============================+

Line 2904: 'PER_PEOPLE_EXTRA_INFO') THEN

2900: END IF;
2901: CLOSE csr_asg;
2902:
2903: IF p_flex_name IN('Extra Person Info DDF',
2904: 'PER_PEOPLE_EXTRA_INFO') THEN
2905: Hr_Utility.set_location('..p_flex_name = '||p_flex_name, 6);
2906: OPEN csr_per_mult_occur(c_information_type => p_flex_context);
2907: FETCH csr_per_mult_occur INTO l_mult_occur;
2908: CLOSE csr_per_mult_occur;

Line 2916: l_tab_name := 'PER_PEOPLE_EXTRA_INFO';

2912: ,c_information_type => p_flex_context);
2913: FETCH csr_pei INTO l_key_val;
2914: CLOSE csr_pei;
2915: l_key_col := 'PERSON_EXTRA_INFO_ID';
2916: l_tab_name := 'PER_PEOPLE_EXTRA_INFO';
2917: ELSE
2918: Hr_Utility.set_location('..l_mult_occur = '||l_mult_occur, 6);
2919: p_error_code := '-20001';
2920: p_err_message := 'Contexts :'||p_flex_context ||

Line 3027: 'PER_PEOPLE_EXTRA_INFO') THEN

3023:
3024: Hr_Utility.set_location('..get_ddf_value ='||l_return_value, 10);
3025:
3026: ELSIF p_flex_name IN ('PER_ASSIGNMENT_EXTRA_INFO',
3027: 'PER_PEOPLE_EXTRA_INFO') THEN
3028: Hr_Utility.set_location('..Calling pqp_utilities.get_df_value', 9);
3029: l_df_seg_value:= Pqp_Utilities.get_df_value
3030: (p_flex_name => p_flex_name
3031: ,p_flex_context => p_flex_context