APPS.PAY_IN_UTILS dependencies on HR_GENERAL

Line 2125: SELECT hr_general.decode_lookup('IN_BANK',org_information1)

2121: RETURN VARCHAR2
2122: IS
2123: CURSOR c_bank_name
2124: IS
2125: SELECT hr_general.decode_lookup('IN_BANK',org_information1)
2126: FROM hr_organization_information
2127: WHERE org_information_context = 'PER_IN_CHALLAN_BANK'
2128: AND org_information_id = p_org_information_id;
2129:

Line 2171: ,'3',hr_general.decode_lookup('IN_STATES',add_information15)

2167: CURSOR c_personal_addr_dff_details
2168: IS
2169: SELECT DECODE(p_segment_no,'1',add_information13
2170: ,'2',add_information14
2171: ,'3',hr_general.decode_lookup('IN_STATES',add_information15)
2172: ,hr_general.decode_lookup('YES_NO',add_information16)
2173: )
2174: FROM per_addresses
2175: WHERE address_id = p_address_id

Line 2172: ,hr_general.decode_lookup('YES_NO',add_information16)

2168: IS
2169: SELECT DECODE(p_segment_no,'1',add_information13
2170: ,'2',add_information14
2171: ,'3',hr_general.decode_lookup('IN_STATES',add_information15)
2172: ,hr_general.decode_lookup('YES_NO',add_information16)
2173: )
2174: FROM per_addresses
2175: WHERE address_id = p_address_id
2176: AND style = 'IN';

Line 2484: SELECT hr_general.decode_lookup('CONTACT',RELATION.CONTACT_TYPE)

2480: RETURN VARCHAR2
2481: IS
2482: CURSOR c_relationship
2483: IS
2484: SELECT hr_general.decode_lookup('CONTACT',RELATION.CONTACT_TYPE)
2485: FROM per_contact_relationships relation,
2486: per_all_people_f ppf,
2487: per_all_assignments_f asg
2488: WHERE relation.contact_person_id = p_contact_person_id