DBA Data[Home] [Help]

APPS.PAY_KR_BAL_UPLOAD dependencies on FND_DATE

Line 60: select nvl(add_months(fnd_date.canonical_to_date(org_information11),

56: PTP.start_date and PTP.end_date);
57: --
58: cursor csr_asg_fytd
59: is
60: select nvl(add_months(fnd_date.canonical_to_date(org_information11),
61: (floor(floor(months_between(p_upload_date,
62: fnd_date.canonical_to_date(org_information11)))/12)*12)),
63: g_eot)
64: from hr_organization_information hoi,

Line 62: fnd_date.canonical_to_date(org_information11)))/12)*12)),

58: cursor csr_asg_fytd
59: is
60: select nvl(add_months(fnd_date.canonical_to_date(org_information11),
61: (floor(floor(months_between(p_upload_date,
62: fnd_date.canonical_to_date(org_information11)))/12)*12)),
63: g_eot)
64: from hr_organization_information hoi,
65: per_assignments_f pa
66: where pa.assignment_id = p_assignment_id