APPS.PAY_IN_UTILS dependencies on HR_GENERAL

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

2106: RETURN VARCHAR2
2107: IS
2108: CURSOR c_bank_name
2109: IS
2110: SELECT hr_general.decode_lookup('IN_BANK',org_information1)
2111: FROM hr_organization_information
2112: WHERE org_information_context = 'PER_IN_CHALLAN_BANK'
2113: AND org_information_id = p_org_information_id;
2114:

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

2152: CURSOR c_personal_addr_dff_details
2153: IS
2154: SELECT DECODE(p_segment_no,'1',add_information13
2155: ,'2',add_information14
2156: ,'3',hr_general.decode_lookup('IN_STATES',add_information15)
2157: ,hr_general.decode_lookup('YES_NO',add_information16)
2158: )
2159: FROM per_addresses
2160: WHERE address_id = p_address_id

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

2153: IS
2154: SELECT DECODE(p_segment_no,'1',add_information13
2155: ,'2',add_information14
2156: ,'3',hr_general.decode_lookup('IN_STATES',add_information15)
2157: ,hr_general.decode_lookup('YES_NO',add_information16)
2158: )
2159: FROM per_addresses
2160: WHERE address_id = p_address_id
2161: AND style = 'IN';

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

2465: RETURN VARCHAR2
2466: IS
2467: CURSOR c_relationship
2468: IS
2469: SELECT hr_general.decode_lookup('CONTACT',RELATION.CONTACT_TYPE)
2470: FROM per_contact_relationships relation,
2471: per_all_people_f ppf,
2472: per_all_assignments_f asg
2473: WHERE relation.contact_person_id = p_contact_person_id