APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 131: FROM hr_organization_information_v org

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

Line 1449: hr_organization_information org

1445: pact.pay_advice_message payroll_message
1446: FROM pay_payrolls_f ppf,
1447: pay_payroll_actions pact,
1448: hr_soft_coding_keyflex flex,
1449: hr_organization_information org
1450: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
1451: AND org.org_information_context = 'Tax Details References'
1452: AND org.org_information1 = flex.segment1
1453: AND ppf.business_group_id = org.organization_id

Line 2359: hr_organization_information org

2355: pact.pay_advice_message payroll_message
2356: FROM pay_payrolls_f ppf,
2357: pay_payroll_actions pact,
2358: hr_soft_coding_keyflex flex,
2359: hr_organization_information org
2360: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
2361: AND org.org_information_context = 'Tax Details References'
2362: AND org.org_information1 = flex.segment1
2363: AND ppf.business_group_id = org.organization_id