DBA Data[Home] [Help]

APPS.PAY_US_PSD_XML dependencies on FF_ARCHIVE_ITEMS

Line 1657: FROM ff_archive_items fai,

1653: and ASG.assignment_type = 'E'
1654: and ASG.primary_flag = 'Y'
1655: and ASG.business_group_id = ppa.business_group_id
1656: and exists ( SELECT NULL
1657: FROM ff_archive_items fai,
1658: ff_archive_item_contexts faic,
1659: FF_CONTEXTS FC
1660: WHERE fai.context1 = paa.assignment_action_id
1661: AND fai.archive_item_id = faic.archive_item_id

Line 1695: FROM ff_archive_items fai,

1691: and ASG.assignment_type = 'E'
1692: and ASG.primary_flag = 'Y'
1693: and ASG.business_group_id = ppa.business_group_id
1694: and exists ( SELECT NULL
1695: FROM ff_archive_items fai,
1696: ff_archive_item_contexts faic,
1697: FF_CONTEXTS FC
1698: WHERE fai.context1 = paa.assignment_action_id
1699: AND fai.archive_item_id = faic.archive_item_id

Line 2064: from ff_archive_items fai

2060: cursor c_chk_payroll_action is
2061: select 'Y'
2062: from dual
2063: where exists (select null
2064: from ff_archive_items fai
2065: where fai.context1 = p_payroll_action_id
2066: and archive_type = 'PPA');
2067: begin
2068: