APPS.PAY_IN_INDIA_BENEFITS dependencies on HR_ORGANIZATION_INFORMATION

Line 54: FROM hr_organization_information hoi

50: IS
51: CURSOR c_element_name(p_business_group_id NUMBER)
52: IS
53: SELECT hoi.org_information3
54: FROM hr_organization_information hoi
55: WHERE hoi.organization_id = p_business_group_id
56: AND org_information_context='PER_IN_REIMBURSE_ELEMENTS';
57:
58:

Line 170: l_medical_bill_element hr_organization_information.org_information2%TYPE ;

166: l_warnings BOOLEAN;
167: l_input_values_rec t_input_values_tab;
168: l_ben_input_values_rec t_input_values_tab;
169: l_business_group_id NUMBER;
170: l_medical_bill_element hr_organization_information.org_information2%TYPE ;
171: l_ltc_element hr_organization_information.org_information2%TYPE ;
172: l_element pay_element_types.element_name%TYPE ;
173: l_count NUMBER;
174: l_assignment_id NUMBER;

Line 171: l_ltc_element hr_organization_information.org_information2%TYPE ;

167: l_input_values_rec t_input_values_tab;
168: l_ben_input_values_rec t_input_values_tab;
169: l_business_group_id NUMBER;
170: l_medical_bill_element hr_organization_information.org_information2%TYPE ;
171: l_ltc_element hr_organization_information.org_information2%TYPE ;
172: l_element pay_element_types.element_name%TYPE ;
173: l_count NUMBER;
174: l_assignment_id NUMBER;
175: l_ltc_element_type_id NUMBER;

Line 1164: FROM hr_organization_information org,

1160: ,p_element_type_id OUT NOCOPY NUMBER)
1161: is
1162: CURSOR csr_element_ids IS
1163: SELECT DECODE(p_element_flag,'MEDBILL',org.org_information1,'MEDPAY',org.org_information2,'LTC_ELE',org.org_information3)
1164: FROM hr_organization_information org,
1165: hr_organization_units unit
1166: WHERE org.org_information_context = 'PER_IN_REIMBURSE_ELEMENTS'
1167: AND org.organization_id =unit.organization_id
1168: AND unit.business_group_id = p_business_group_id;

Line 1723: hr_organization_information org

1719: CURSOR lock_dtls
1720: IS
1721: SELECT NVL(DECODE(p_ltc_or_med,'LTC',org_information1,'MED',org_information2),'N') lock_flag
1722: FROM
1723: hr_organization_information org
1724: ,per_people_f person
1725: WHERE
1726: org.org_information_context = 'PER_IN_BENEFITS_DECL_INFO'
1727: AND org.organization_id = person.business_group_id