APPS.HR_JPBAL dependencies on HR_ORGANIZATION_INFORMATION

Line 627: hr_organization_information hoi,

623: FROM pay_assignment_actions paa,
624: pay_payroll_actions ppa,
625: ff_database_items ffd,
626: ff_user_entities ffu,
627: hr_organization_information hoi,
628: pay_defined_balances pdb
629: WHERE paa.assignment_action_id=p_assignment_action_id
630: AND ppa.payroll_action_id=paa.payroll_action_id
631: AND ffd.user_name=p_item_name

Line 1647: hr_organization_information HROG

1643: floor(months_between(PACT.date_earned,nvl(FND_DATE.CANONICAL_TO_DATE(HROG.org_information11),
1644: trunc(PACT.date_earned,'YYYY')))/12)*12) last_start_date
1645: FROM pay_assignment_actions ASSACT,
1646: pay_payroll_actions PACT,
1647: hr_organization_information HROG
1648: WHERE ASSACT.assignment_action_id = c_assignment_action_id
1649: AND PACT.payroll_action_id = ASSACT.payroll_action_id
1650: AND HROG.organization_id = PACT.business_group_id
1651: AND HROG.org_information_context = 'Business Group Information';

Line 1818: hr_organization_information HROG

1814: floor(months_between(PACT.effective_date,nvl(FND_DATE.CANONICAL_TO_DATE(HROG.org_information11),
1815: trunc(PACT.effective_date,'YYYY')))/12)*12) last_start_date
1816: FROM pay_assignment_actions ASSACT,
1817: pay_payroll_actions PACT,
1818: hr_organization_information HROG
1819: WHERE ASSACT.assignment_action_id = c_assignment_action_id
1820: AND PACT.payroll_action_id = ASSACT.payroll_action_id
1821: AND HROG.organization_id = PACT.business_group_id
1822: AND HROG.org_information_context = 'Business Group Information';