DBA Data[Home] [Help]

APPS.PAY_NL_EOY_PKG dependencies on DUAL

Line 1052: select p_business_group_id FROM DUAL)

1048: and posv.organization_structure_id=p_org_struct_id
1049: and posv.business_group_id = pose.business_group_id
1050: and posv.business_group_id=p_business_group_id
1051: UNION ALL
1052: select p_business_group_id FROM DUAL)
1053: and nvl(p_hr_org_id,organization_id)=organization_id
1054: --and fnd_date.canonical_to_date(p_date) between effective_start_date and effective_end_date --12322620
1055: --12322620
1056: AND asg.effective_end_date >= fnd_date.canonical_to_date(p_date)