DBA Data[Home] [Help]

APPS.PAY_CN_AUDIT_XMLGEN dependencies on HR_SOFT_CODING_KEYFLEX

Line 504: hr_soft_coding_keyflex scl

500: and paf.effective_end_date >= g_start_date
501: and paf.effective_start_date <= g_end_date)
502: AND EXISTS (SELECT 1
503: FROM per_assignments_f paf,
504: hr_soft_coding_keyflex scl
505: WHERE paf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
506: AND scl.segment1 = hou.organization_id
507: AND paf.business_group_id = g_bg_id
508: )

Line 538: hr_soft_coding_keyflex scl

534: and paf.effective_end_date >= g_start_date
535: and paf.effective_start_date <= g_end_date)
536: AND EXISTS (SELECT 1
537: FROM per_assignments_f paf,
538: hr_soft_coding_keyflex scl
539: WHERE paf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
540: AND scl.segment1 = hou.organization_id
541: AND paf.business_group_id = g_bg_id
542: )

Line 1183: hr_soft_coding_keyflex scl

1179: AND hou.organization_id = hoi.organization_id
1180: AND hou.business_group_id = g_bg_id
1181: AND EXISTS (SELECT 1
1182: FROM per_assignments_f paf,
1183: hr_soft_coding_keyflex scl
1184: WHERE paf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
1185: AND scl.segment1 = hou.organization_id
1186: AND paf.business_group_id = g_bg_id
1187: )