DBA Data[Home] [Help]

APPS.PAY_DK_TCR dependencies on FND_DATE

Line 80: and pap.effective_start_date >= fnd_date.canonical_to_date(p_start_date)

76: and paa.PRIMARY_FLAG='Y'
77: and pap.person_id=paa.person_id
78: and pap.effective_start_date = (SELECT MAX(date_start) lhd FROM per_periods_of_service
79: WHERE person_id=pap.person_id)
80: and pap.effective_start_date >= fnd_date.canonical_to_date(p_start_date)
81: and pap.effective_start_date = paa.effective_start_date;
82:
83: rg_csr_get_person_id csr_get_person_id%ROWTYPE;
84: