APPS.PAY_CN_BAL_UPLOAD dependencies on FND_DATE

Line 46: SELECT NVL(ADD_MONTHS(fnd_date.canonical_to_date(HOI.ORG_INFORMATION11)

42: -- Returns the start date of the fiscal year.
43: CURSOR csr_fiscal_year ( p_assignment_id NUMBER
44: , p_upload_date DATE
45: ) IS
46: SELECT NVL(ADD_MONTHS(fnd_date.canonical_to_date(HOI.ORG_INFORMATION11)
47: ,12*(floor(months_between(p_upload_date
48: ,fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/12)))
49: ,END_OF_TIME)
50: FROM per_assignments_f ASS

Line 48: ,fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/12)))

44: , p_upload_date DATE
45: ) IS
46: SELECT NVL(ADD_MONTHS(fnd_date.canonical_to_date(HOI.ORG_INFORMATION11)
47: ,12*(floor(months_between(p_upload_date
48: ,fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/12)))
49: ,END_OF_TIME)
50: FROM per_assignments_f ASS
51: ,hr_organization_information HOI
52: WHERE ASS.assignment_id = p_assignment_id

Line 75: SELECT NVL(ADD_MONTHS(fnd_date.canonical_to_date(HOI.ORG_INFORMATION11)

71: -- Returns the start date of the fiscal quarter.
72: CURSOR csr_fiscal_quarter( p_assignment_id NUMBER
73: , p_upload_date DATE
74: ) IS
75: SELECT NVL(ADD_MONTHS(fnd_date.canonical_to_date(HOI.ORG_INFORMATION11)
76: , 3*(FLOOR(MONTHS_BETWEEN(p_upload_date
77: , fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/3)))
78: , END_OF_TIME)
79: FROM per_assignments_f ASS

Line 77: , fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/3)))

73: , p_upload_date DATE
74: ) IS
75: SELECT NVL(ADD_MONTHS(fnd_date.canonical_to_date(HOI.ORG_INFORMATION11)
76: , 3*(FLOOR(MONTHS_BETWEEN(p_upload_date
77: , fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/3)))
78: , END_OF_TIME)
79: FROM per_assignments_f ASS
80: ,hr_organization_information HOI
81: WHERE ASS.assignment_id = p_assignment_id