APPS.PAY_IN_MED_WEB_ADI dependencies on HR_ORGANIZATION_INFORMATION

Line 83: FROM hr_organization_information hoi

79: CURSOR c_element_name(p_business_group_id NUMBER)
80: IS
81: SELECT hoi.org_information1
82: ,hoi.org_information2
83: FROM hr_organization_information hoi
84: WHERE hoi.organization_id = p_business_group_id
85: AND org_information_context='PER_IN_REIMBURSE_ELEMENTS';
86:
87:

Line 190: l_medical_bill_element hr_organization_information.org_information2%TYPE ;

186: l_warnings BOOLEAN;
187: l_input_values_rec t_input_values_tab;
188: l_ben_input_values_rec t_input_values_tab;
189: l_business_group_id NUMBER;
190: l_medical_bill_element hr_organization_information.org_information2%TYPE ;
191: l_medical_ben_element hr_organization_information.org_information2%TYPE ;
192: l_element pay_element_types.element_name%TYPE ;
193: l_count NUMBER;
194: l_assignment_id NUMBER;

Line 191: l_medical_ben_element hr_organization_information.org_information2%TYPE ;

187: l_input_values_rec t_input_values_tab;
188: l_ben_input_values_rec t_input_values_tab;
189: l_business_group_id NUMBER;
190: l_medical_bill_element hr_organization_information.org_information2%TYPE ;
191: l_medical_ben_element hr_organization_information.org_information2%TYPE ;
192: l_element pay_element_types.element_name%TYPE ;
193: l_count NUMBER;
194: l_assignment_id NUMBER;
195: l_bill_element_type_id NUMBER;

Line 984: FROM hr_organization_information hoi

980: IS
981: CURSOR c_element_name(p_business_group_id NUMBER)
982: IS
983: SELECT hoi.org_information3
984: FROM hr_organization_information hoi
985: WHERE hoi.organization_id = p_business_group_id
986: AND org_information_context='PER_IN_REIMBURSE_ELEMENTS';
987:
988:

Line 1092: l_medical_bill_element hr_organization_information.org_information2%TYPE ;

1088: l_warnings BOOLEAN;
1089: l_input_values_rec t_input_values_tab;
1090: l_ben_input_values_rec t_input_values_tab;
1091: l_business_group_id NUMBER;
1092: l_medical_bill_element hr_organization_information.org_information2%TYPE ;
1093: l_ltc_element hr_organization_information.org_information2%TYPE ;
1094: l_element pay_element_types.element_name%TYPE ;
1095: l_count NUMBER;
1096: l_assignment_id NUMBER;

Line 1093: l_ltc_element hr_organization_information.org_information2%TYPE ;

1089: l_input_values_rec t_input_values_tab;
1090: l_ben_input_values_rec t_input_values_tab;
1091: l_business_group_id NUMBER;
1092: l_medical_bill_element hr_organization_information.org_information2%TYPE ;
1093: l_ltc_element hr_organization_information.org_information2%TYPE ;
1094: l_element pay_element_types.element_name%TYPE ;
1095: l_count NUMBER;
1096: l_assignment_id NUMBER;
1097: l_ltc_element_type_id NUMBER;