APPS.PAY_AU_SOE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 155: from hr_organization_information hoi,

151:
152: cursor currency_code
153: (c_business_group_id hr_organization_units.business_group_id%type) is
154: select fcu.currency_code
155: from hr_organization_information hoi,
156: hr_organization_units hou,
157: fnd_currencies fcu
158: where hou.business_group_id = c_business_group_id
159: and hou.organization_id = hoi.organization_id

Line 973: hr_organization_information hoi,

969: ,p_business_group_id number)
970: is
971: select hoi.org_information2
972: from
973: hr_organization_information hoi,
974: hr_organization_units hou,
975: pay_personal_payment_methods_f pppm
976: where
977: hoi.org_information_context='AU_SUPER_FUND'

Line 1408: from hr_organization_information hoi,

1404: and p_effective_date between popm.effective_start_date and popm.effective_end_date;
1405:
1406: Cursor org_currency_code(c_business_group_id hr_organization_units.business_group_id%type) is
1407: select hoi.org_information10
1408: from hr_organization_information hoi,
1409: hr_organization_units hou
1410: where hou.business_group_id = c_business_group_id
1411: and hou.organization_id = hoi.organization_id
1412: and hoi.org_information_context = 'Business Group Information';

Line 1522: from hr_organization_information

1518: and lei_information1 = 'PAYSLIP';
1519:
1520: cursor get_org_eit (p_organization_id number) is
1521: select org_information3
1522: from hr_organization_information
1523: where organization_id = p_organization_id
1524: and org_information_context = 'HR_SELF_SERVICE_ORG_PREFERENCE'
1525: and org_information1 = 'PAYSLIP';
1526:

Line 1529: from hr_organization_information

1525: and org_information1 = 'PAYSLIP';
1526:
1527: cursor get_bg_eit (p_business_group_id number) is
1528: select org_information3
1529: from hr_organization_information
1530: where organization_id = p_business_group_id
1531: and org_information_context = 'HR_SELF_SERVICE_BG_PREFERENCE'
1532: and org_information1 = 'PAYSLIP';
1533: