DBA Data[Home] [Help]

APPS.PSP_LABOR_DIST dependencies on PSP_SALARY_CAP_OVERRIDES

Line 6908: from psp_salary_cap_overrides cap,

6904: substr(l_sponsor_str, instr(l_sponsor_str,fnd.lookup_code)+length(fnd.lookup_code),15) sponsor_id,
6905: cap.annual_salary_cap / l_no_units_per_year / l_tp_no_of_work_days daily_cap_rate,
6906: funding_source_code,
6907: annual_salary_cap
6908: from psp_salary_cap_overrides cap,
6909: fnd_lookup_values fnd
6910: where cap.start_date < l_tp_end_date
6911: and cap.end_date > l_tp_start_date
6912: and cap.funding_source_code = fnd.lookup_code

Line 7222: from psp_salary_cap_overrides over

7218: nvl(pod.award_id,
7219: nvl(pea.award_id, pdls.award_id))) = awd.award_id
7220: and not exists
7221: (select 1
7222: from psp_salary_cap_overrides over
7223: where nvl(psl.project_id, nvl(pod.project_id, nvl(pea.project_id, pdls.project_id)))
7224: = over.project_id
7225: and over.currency_code = ppc.currency_code
7226: and over.funding_source_code = '||''''||cap_rec.funding_source_code||''''||'