APPS.PSP_GENERAL dependencies on PAY_ALL_PAYROLLS_F

Line 1298: FROM pay_all_payrolls_f pap

1294: RETURN VARCHAR2 IS
1295:
1296: CURSOR c1 IS
1297: SELECT payroll_name
1298: FROM pay_all_payrolls_f pap
1299: WHERE pap.payroll_id = p_payroll_id
1300: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1301:
1302: v_name VARCHAR2(80);

Line 1941: from pay_all_payrolls_f papf

1937: IS
1938:
1939: cursor eff_dates is
1940: select max(papf.effective_end_date),min(papf.effective_start_date)
1941: from pay_all_payrolls_f papf
1942: WHERE papf.payroll_id = p_payroll_id;
1943:
1944: max_eff_end_date date;
1945: min_eff_start_date date;

Line 1969: from pay_all_payrolls_f papf

1965:
1966: FUNCTION get_payroll_name_er(p_payroll_id IN NUMBER, p_effective_date IN DATE) RETURN VARCHAR2 IS
1967: cursor eff_dates is
1968: select max(papf.effective_end_date),min(papf.effective_start_date)
1969: from pay_all_payrolls_f papf
1970: WHERE papf.payroll_id = p_payroll_id;
1971:
1972: cursor c1(p_calculated_date date)
1973: is

Line 1975: from pay_all_payrolls_f papf

1971:
1972: cursor c1(p_calculated_date date)
1973: is
1974: select payroll_name
1975: from pay_all_payrolls_f papf
1976: WHERE papf.payroll_id = p_payroll_id
1977: and p_calculated_date between papf.effective_start_date and papf.effective_end_date;
1978:
1979: l_payroll_name varchar2(240);