APPS.HR_JPRTS dependencies on HR_ORGANIZATION_INFORMATION

Line 14: FROM hr_organization_information

10: -- Bug.2597843
11: --
12: cursor csr_fiscal_year_start_date(p_business_group_id number) is
13: SELECT fnd_date.canonical_to_date(org_information11)
14: FROM hr_organization_information
15: WHERE org_information_context = 'Business Group Information'
16: AND organization_id = p_business_group_id;
17: g_business_group_id number;
18: g_fiscal_year_start_date date;

Line 185: FROM hr_organization_information

181: --
182: cursor csr_start_date
183: is
184: SELECT to_char(nvl(FND_DATE.CANONICAL_TO_DATE(org_information11),to_date(to_char(p_input_date,'YYYY')||'/04/01','YYYY/MM/DD')),'DD-MM-YYYY')
185: FROM hr_organization_information
186: WHERE org_information_context='Business Group Information'
187: AND organization_id = p_business_group_id;
188: */
189: BEGIN

Line 265: FROM hr_organization_information

261: --
262: cursor csr_start_date
263: is
264: SELECT to_char(nvl(FND_DATE.CANONICAL_TO_DATE(org_information11),to_date(to_char(p_input_date,'YYYY')||'/04/01','YYYY/MM/DD')),'DD-MM-YYYY')
265: FROM hr_organization_information
266: WHERE org_information_context='Business Group Information'
267: AND organization_id = p_business_group_id;
268: */
269: BEGIN

Line 643: -- hr_organization_information HROG

639: -- nvl(fnd_date.canonical_to_date(HROG.org_information11), trunc(BACT.date_earned, 'YYYY')))
640: -- / 12) * 12) start_date
641: -- from pay_assignment_actions BAL_ASSACT,
642: -- pay_payroll_actions BACT,
643: -- hr_organization_information HROG
644: -- where BAL_ASSACT.assignment_action_id = assact_id
645: -- and BACT.payroll_action_id = BAL_ASSACT.payroll_action_id
646: -- and HROG.organization_id = BACT.business_group_id
647: -- and HROG.org_information_context = 'Business Group Information') V1,

Line 682: from hr_organization_information HROG,

678: floor(
679: months_between( BACT.date_earned,
680: nvl(fnd_date.canonical_to_date(HROG.org_information11), trunc(BACT.date_earned, 'YYYY')))
681: / 12) * 12) start_date
682: from hr_organization_information HROG,
683: pay_payroll_actions BACT,
684: pay_assignment_actions BAL_ASSACT
685: where BAL_ASSACT.assignment_action_id = assact_id
686: and BACT.payroll_action_id = BAL_ASSACT.payroll_action_id