APPS.PAY_JP_PRE_TAX_PKG dependencies on HR_ASSIGNMENT_SETS

Line 423: AND EXISTS ( select null from hr_assignment_sets

419: INTO l_dummy
420: FROM HR_ASSIGNMENT_SET_AMENDMENTS
421: WHERE ASSIGNMENT_SET_ID = p_assignment_set_id
422: AND ROWNUM = 1
423: AND EXISTS ( select null from hr_assignment_sets
424: where ASSIGNMENT_SET_ID = p_assignment_set_id
425: AND FORMULA_ID IS NULL
426: );
427: RETURN l_dummy;

Line 552: p_assignment_set_id IN hr_assignment_sets.assignment_set_id%TYPE,

548: p_errbuf OUT NOCOPY VARCHAR2,
549: p_retcode OUT NOCOPY VARCHAR2,
550: p_business_group_id IN pay_payroll_actions.business_group_id%TYPE,
551: p_payroll_id IN pay_payroll_actions.business_group_id%TYPE,
552: p_assignment_set_id IN hr_assignment_sets.assignment_set_id%TYPE,
553: p_from_date IN varchar2,
554: p_to_date IN varchar2) IS
555: --
556: l_from_date date;

Line 639: FROM hr_assignment_sets

635: g_all_exclusions_flag := chk_all_exclusions(l_ass_set_id);
636:
637: -- assignment set is passed as parameter
638: SELECT formula_id INTO l_formula_id
639: FROM hr_assignment_sets
640: WHERE assignment_set_id = l_ass_set_id;
641:
642: l_assact_tab.DELETE;
643: