APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 133: FROM hr_organization_information_v org

129: org.org_information3,
130: org.org_information4,
131: org.org_information5,
132: org.org_information6
133: FROM hr_organization_information_v org
134: WHERE org.org_information_context = p_context
135: AND org.organization_id = p_bg_id;
136:
137: CURSOR csr_balance_name(p_balance_type_id NUMBER,

Line 1515: hr_organization_information org

1511: pact.pay_advice_message payroll_message
1512: FROM pay_payrolls_f ppf,
1513: pay_payroll_actions pact,
1514: hr_soft_coding_keyflex flex,
1515: hr_organization_information org
1516: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
1517: AND org.org_information_context = 'Tax Details References'
1518: AND org.org_information1 = flex.segment1
1519: AND ppf.business_group_id = org.organization_id

Line 2455: hr_organization_information org

2451: pact.pay_advice_message payroll_message
2452: FROM pay_payrolls_f ppf,
2453: pay_payroll_actions pact,
2454: hr_soft_coding_keyflex flex,
2455: hr_organization_information org
2456: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
2457: AND org.org_information_context = 'Tax Details References'
2458: AND org.org_information1 = flex.segment1
2459: AND ppf.business_group_id = org.organization_id