DBA Data[Home] [Help]

APPS.PAY_CA_YEPP_MISS_ASSIGN_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 377: hr_soft_coding_keyflex SCL

373: cp_pre_id number) is
374: SELECT DISTINCT ASG.assignment_id ass_id
375: FROM per_all_assignments_f ASG,
376: pay_all_payrolls_f PPY,
377: hr_soft_coding_keyflex SCL
378: WHERE ASG.business_group_id + 0 = cp_bus_grp
379: AND ASG.assignment_type = 'E'
380: AND ASG.effective_start_date <= add_months(cp_effective_date, 12) - 1
381: AND ASG.effective_end_date >= cp_effective_date

Line 425: hr_soft_coding_keyflex SCL

421: cp_pre_id number) is
422: SELECT DISTINCT ASG.assignment_id ass_id
423: FROM per_all_assignments_f ASG,
424: pay_all_payrolls_f PPY,
425: hr_soft_coding_keyflex SCL
426: WHERE ASG.business_group_id + 0 = cp_bus_grp
427: AND ASG.assignment_type = 'E'
428: AND ASG.effective_start_date <= add_months(cp_effective_date, 12) - 1
429: AND ASG.effective_end_date >= cp_effective_date