APPS.PQP_PENSION_EXTRACTS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2851: l_organization_id hr_all_organization_units.organization_id%TYPE;

2847: l_assignment_extra_info_id csr_aei%ROWTYPE;
2848: l_person_extra_info_id csr_pei%ROWTYPE;
2849: l_asg_rec csr_asg%ROWTYPE;
2850:
2851: l_organization_id hr_all_organization_units.organization_id%TYPE;
2852: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_DDF_DF_Value';
2853: l_key_val NUMBER;
2854: l_key_col VARCHAR2(150);
2855: l_df_key_val VARCHAR2(150);

Line 3683: FROM hr_all_organization_units

3679:
3680: CURSOR csr_org_name (c_org_id IN NUMBER
3681: )IS
3682: SELECT NAME
3683: FROM hr_all_organization_units
3684: WHERE organization_id =c_org_id;
3685:
3686: CURSOR csr_person_type (c_person_type_id IN NUMBER
3687: )IS

Line 3705: l_org_name hr_all_organization_units.NAME%TYPE;

3701: l_element_name pay_element_types_f.element_name%TYPE;
3702: l_gre_name hr_organization_units.NAME%TYPE ;
3703: l_payroll_name pay_payrolls_f.payroll_name%TYPE ;
3704: l_con_set_name pay_consolidation_sets.consolidation_set_name%TYPE;
3705: l_org_name hr_all_organization_units.NAME%TYPE;
3706: l_person_type per_person_types.user_person_type%TYPE;
3707: l_location hr_locations_all.location_code%TYPE;
3708: BEGIN
3709: hr_utility.set_location('Entering: '||l_proc_name, 5);