DBA Data[Home] [Help]

APPS.PAY_PPR_BUS dependencies on PAY_ASS_STATUS_TYPES_PLUS_STD

Line 543: FROM pay_ass_status_types_plus_std astp

539: l_proc varchar2(72) := g_package||'chk_formula_id';
540:
541: cursor c_assignment_status is
542: SELECT astp.user_status
543: FROM pay_ass_status_types_plus_std astp
544: WHERE nvl(astp.assignment_status_type_id,-1) = nvl(p_assignment_status_type_id,-1)
545: and ((astp.legislation_code =
546: nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)))
547: or ( astp.legislation_code is null and