APPS.PQP_PENSION_EXTRACTS dependencies on HR_ORGANIZATION_INFORMATION

Line 2829: FROM hr_organization_information

2825:
2826: CURSOR csr_info_id (c_organization_id IN NUMBER
2827: ,c_flex_context IN VARCHAR2) IS
2828: SELECT org_information_id
2829: FROM hr_organization_information
2830: WHERE organization_id = c_organization_id
2831: AND org_information_context = c_flex_context;
2832:
2833: --

Line 2870: |Org Developer DF |Org Developer DF |HR_ORGANIZATION_INFORMATION |

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: +=============================+=========================+============================+
2874: */

Line 2954: 'HR_ORGANIZATION_INFORMATION') THEN

2950: RETURN l_return_value;
2951: END IF;
2952:
2953: ELSIF p_flex_name IN('Org Developer DF',
2954: 'HR_ORGANIZATION_INFORMATION') THEN
2955: IF g_legislation_code = 'MX' THEN
2956:
2957: IF p_flex_context IN ('MX_SOC_SEC_DETAILS') THEN
2958:

Line 2975: l_tab_name := 'HR_ORGANIZATION_INFORMATION';

2971: FETCH csr_info_id INTO l_key_val;
2972: CLOSE csr_info_id;
2973:
2974: l_key_col := 'ORG_INFORMATION_ID';
2975: l_tab_name := 'HR_ORGANIZATION_INFORMATION';
2976: Hr_Utility.set_location('..g_gre_org_id = '||g_gre_org_id, 7);
2977: Hr_Utility.set_location('..p_flex_context = '||p_flex_context, 7);
2978: Hr_Utility.set_location('..l_key_val = '||l_key_val, 7);
2979: END IF;