APPS.HR_JPRTS dependencies on FND_DATE

Line 13: SELECT fnd_date.canonical_to_date(org_information11)

9: -- If not entered, January 1st is used instead.
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;

Line 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')

180: l_start_date_year number(4);
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: */

Line 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')

260: l_start_date_year number(4);
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: */

Line 639: -- nvl(fnd_date.canonical_to_date(HROG.org_information11), trunc(BACT.date_earned, 'YYYY')),

635: -- BAL_ASSACT.assignment_id assignment_id,
636: -- BAL_ASSACT.action_sequence action_sequence,
637: -- BACT.date_earned date_earned,
638: -- add_months(
639: -- nvl(fnd_date.canonical_to_date(HROG.org_information11), trunc(BACT.date_earned, 'YYYY')),
640: -- floor(
641: -- months_between( BACT.date_earned,
642: -- nvl(fnd_date.canonical_to_date(HROG.org_information11), trunc(BACT.date_earned, 'YYYY')))
643: -- / 12) * 12) start_date

Line 642: -- nvl(fnd_date.canonical_to_date(HROG.org_information11), trunc(BACT.date_earned, 'YYYY')))

638: -- add_months(
639: -- nvl(fnd_date.canonical_to_date(HROG.org_information11), trunc(BACT.date_earned, 'YYYY')),
640: -- floor(
641: -- months_between( BACT.date_earned,
642: -- nvl(fnd_date.canonical_to_date(HROG.org_information11), trunc(BACT.date_earned, 'YYYY')))
643: -- / 12) * 12) start_date
644: -- from pay_assignment_actions BAL_ASSACT,
645: -- pay_payroll_actions BACT,
646: -- hr_organization_information HROG

Line 677: nvl(fnd_date.canonical_to_date(HROG.org_information11), trunc(BACT.date_earned, 'YYYY')),

673: --
674: -- When null, apply 1st January
675: --
676: add_months(
677: nvl(fnd_date.canonical_to_date(HROG.org_information11), trunc(BACT.date_earned, 'YYYY')),
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

Line 680: nvl(fnd_date.canonical_to_date(HROG.org_information11), trunc(BACT.date_earned, 'YYYY')))

676: add_months(
677: nvl(fnd_date.canonical_to_date(HROG.org_information11), trunc(BACT.date_earned, 'YYYY')),
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