APPS.PQP_FEDHR_USPAY_INT_UTILS dependencies on PER_PAY_BASES

Line 263: CURSOR chk_per_pay_bases(p_business_group_id

259: p_business_group_id IN NUMBER ,
260: p_effective_date IN DATE
261: ) RETURN VARCHAR2 IS
262:
263: CURSOR chk_per_pay_bases(p_business_group_id
264: per_business_groups.business_group_id%TYPE,
265: p_salary_basis VARCHAR2,
266: p_effective_date DATE) IS
267: SELECT element_name

Line 268: FROM per_pay_bases ppb,

264: per_business_groups.business_group_id%TYPE,
265: p_salary_basis VARCHAR2,
266: p_effective_date DATE) IS
267: SELECT element_name
268: FROM per_pay_bases ppb,
269: pay_element_types_f pet,
270: pay_input_values_f piv
271: WHERE ppb.business_group_id = p_business_group_id
272: AND ppb.business_group_id = pet.business_group_id

Line 292: FOR c_ppb IN chk_per_pay_bases (p_business_group_id =>

288: (p_business_group_id => p_business_group_id,
289: p_fedhr_element_name => 'Basic Salary Rate') = TRUE)
290: THEN
291: -- {
292: FOR c_ppb IN chk_per_pay_bases (p_business_group_id =>
293: p_business_group_id ,
294: p_salary_basis => p_salary_basis,
295: p_effective_date => p_effective_date)
296: LOOP

Line 343: CURSOR chk_per_pay_bases(p_business_group_id

339: p_assignment_id IN VARCHAR2 ,
340: p_business_group_id IN NUMBER ,
341: p_effective_date IN DATE
342: ) RETURN VARCHAR2 IS
343: CURSOR chk_per_pay_bases(p_business_group_id
344: per_business_groups.business_group_id%TYPE,
345: p_salary_basis_id NUMBER,
346: p_effective_date DATE) IS
347: SELECT element_name

Line 348: FROM per_pay_bases ppb,

344: per_business_groups.business_group_id%TYPE,
345: p_salary_basis_id NUMBER,
346: p_effective_date DATE) IS
347: SELECT element_name
348: FROM per_pay_bases ppb,
349: pay_element_types_f pet,
350: pay_input_values_f piv
351: WHERE ppb.business_group_id = p_business_group_id
352: AND ppb.business_group_id = pet.business_group_id

Line 391: FOR c_ppb IN chk_per_pay_bases (p_business_group_id =>

387: p_effective_date => p_effective_date)
388: LOOP
389: l_sal_basis_id := c_assgn.pay_basis_id;
390: END LOOP;
391: FOR c_ppb IN chk_per_pay_bases (p_business_group_id =>
392: p_business_group_id ,
393: p_salary_basis_id => l_sal_basis_id,
394: p_effective_date => p_effective_date)
395: LOOP