DBA Data[Home] [Help]

APPS.PAY_US_W4_WF dependencies on HR_SOFT_CODING_KEYFLEX

Line 417: ,hr_soft_coding_keyflex hsc

413: and org.organization_id =
414: (select /*+ ordered */ hsc.segment1 --Bug 3362223
415: from pay_stat_trans_audit pta
416: ,per_assignments_f paf
417: ,hr_soft_coding_keyflex hsc
418: where hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
419: and paf.assignment_id = pta.assignment_id
420: and pta.source4 = ln_transaction_id
421: and pta.source4_type = 'TRANSACTION_ID'

Line 431: ,hr_soft_coding_keyflex hsc

427: select org.org_information1
428: from hr_organization_information org
429: ,per_assignments_f paf
430: ,pay_stat_trans_audit pta
431: ,hr_soft_coding_keyflex hsc
432: where org.organization_id = hsc.segment1
433: and hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
434: and paf.assignment_id = pta.assignment_id
435: and pta.source4 = ln_transaction_id

Line 600: ,hr_soft_coding_keyflex hsc

596: and pta.transaction_parent_id is null
597: and org.org_information_context ||'' = 'Contact Information'
598: and org.organization_id = (select hsc.segment1
599: from per_assignments_f paf
600: ,hr_soft_coding_keyflex hsc
601: where paf.assignment_id = ln_current_assignment_id
602: and hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
603: and pta.transaction_effective_date
604: between paf.effective_start_date