APPS.GHR_PA_REQUESTS_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 983: l_pos_organization_id hr_organization_information.organization_id%TYPE;

979: l_business_group_id hr_all_positions_f.business_group_id%type;
980: l_pos_ei_grade_data per_position_extra_info%rowtype;
981: l_pos_ei_grp1_data per_position_extra_info%rowtype;
982:
983: l_pos_organization_id hr_organization_information.organization_id%TYPE;
984: l_assignment_id per_all_assignments_f.assignment_id%type;
985: l_retained_grade ghr_pay_calc.retained_grade_rec_type;
986: l_person_id per_all_assignments_f.person_id%type;
987: l_prd VARCHAR2(30);

Line 1030: FROM hr_organization_information oi

1026: ,oi.org_information7 position_org_line3
1027: ,oi.org_information8 position_org_line4
1028: ,oi.org_information9 position_org_line5
1029: ,oi.org_information10 position_org_line6
1030: FROM hr_organization_information oi
1031: WHERE oi.organization_id = p_org_id
1032: AND oi.org_information_context = 'GHR_US_ORG_REPORTING_INFO';
1033:
1034: BEGIN

Line 1212: FROM hr_organization_information oi

1208: ,oi.org_information7 position_org_line3
1209: ,oi.org_information8 position_org_line4
1210: ,oi.org_information9 position_org_line5
1211: ,oi.org_information10 position_org_line6
1212: FROM hr_organization_information oi
1213: WHERE oi.organization_id = p_org_id
1214: AND oi.org_information_context = 'GHR_US_ORG_REPORTING_INFO';
1215:
1216: --l_pos_org_id NUMBER;