DBA Data[Home] [Help]

APPS.PAY_NL_EOY_PKG dependencies on DUAL

Line 1000: select p_business_group_id FROM DUAL)

996: and posv.organization_structure_id=p_org_struct_id
997: and posv.business_group_id = pose.business_group_id
998: and posv.business_group_id=p_business_group_id
999: UNION ALL
1000: select p_business_group_id FROM DUAL)
1001: and nvl(p_hr_org_id,organization_id)=organization_id
1002: and fnd_date.canonical_to_date(p_date) between effective_start_date and effective_end_date
1003: and asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
1004: and scl.segment12 is not null