DBA Data[Home] [Help]

APPS.PSP_LABOR_DIST dependencies on PSP_SALARY_CAPS

Line 6926: from psp_salary_caps cap2,

6922: substr(l_sponsor_str, instr(l_sponsor_str,fnd2.lookup_code)+length(fnd2.lookup_code),15) sponsor_id,
6923: cap2.annual_salary_cap / l_no_units_per_year / l_tp_no_of_work_days daily_cap_rate,
6924: funding_source_code,
6925: annual_salary_cap
6926: from psp_salary_caps cap2,
6927: fnd_lookup_values fnd2
6928: where cap2.start_date < l_tp_end_date
6929: and cap2.end_date > l_tp_start_date
6930: and fnd2.enabled_flag = 'Y'

Line 8495: from psp_salary_caps

8491:
8492: cursor check_salary_cap_exists(p_sponsor_code in varchar2,
8493: p_date in date) is
8494: select 1
8495: from psp_salary_caps
8496: where funding_source_code = p_sponsor_code
8497: and p_date between start_date and end_date;
8498:
8499: l_error_flag varchar2(1);