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 1667: hr_organization_information HROG

1663: floor(months_between(PACT.date_earned,nvl(FND_DATE.CANONICAL_TO_DATE(HROG.org_information11),
1664: trunc(PACT.date_earned,'YYYY')))/12)*12) last_start_date
1665: FROM pay_assignment_actions ASSACT,
1666: pay_payroll_actions PACT,
1667: hr_organization_information HROG
1668: WHERE ASSACT.assignment_action_id = c_assignment_action_id
1669: AND PACT.payroll_action_id = ASSACT.payroll_action_id
1670: AND HROG.organization_id = PACT.business_group_id
1671: AND HROG.org_information_context = 'Business Group Information';

Line 1838: hr_organization_information HROG

1834: floor(months_between(PACT.effective_date,nvl(FND_DATE.CANONICAL_TO_DATE(HROG.org_information11),
1835: trunc(PACT.effective_date,'YYYY')))/12)*12) last_start_date
1836: FROM pay_assignment_actions ASSACT,
1837: pay_payroll_actions PACT,
1838: hr_organization_information HROG
1839: WHERE ASSACT.assignment_action_id = c_assignment_action_id
1840: AND PACT.payroll_action_id = ASSACT.payroll_action_id
1841: AND HROG.organization_id = PACT.business_group_id
1842: AND HROG.org_information_context = 'Business Group Information';