APPS.HXC_DEPOSIT_CHECKS dependencies on HXC_AP_DETAIL_LINKS

Line 1471: p_detail_id in hxc_ap_detail_links.time_building_block_id%type,

1467: Function detail_locked
1468: (p_timecard_props in hxc_timecard_prop_table_type,
1469: p_resource_id in hxc_time_building_blocks.resource_id%type,
1470: p_date in date,
1471: p_detail_id in hxc_ap_detail_links.time_building_block_id%type,
1472: p_detail_ovn in hxc_ap_detail_links.time_building_block_ovn%type
1473: ) return boolean is
1474:
1475: cursor c_detail_approved

Line 1472: p_detail_ovn in hxc_ap_detail_links.time_building_block_ovn%type

1468: (p_timecard_props in hxc_timecard_prop_table_type,
1469: p_resource_id in hxc_time_building_blocks.resource_id%type,
1470: p_date in date,
1471: p_detail_id in hxc_ap_detail_links.time_building_block_id%type,
1472: p_detail_ovn in hxc_ap_detail_links.time_building_block_ovn%type
1473: ) return boolean is
1474:
1475: cursor c_detail_approved
1476: (p_detail_id in hxc_ap_detail_links.time_building_block_id%type,

Line 1476: (p_detail_id in hxc_ap_detail_links.time_building_block_id%type,

1472: p_detail_ovn in hxc_ap_detail_links.time_building_block_ovn%type
1473: ) return boolean is
1474:
1475: cursor c_detail_approved
1476: (p_detail_id in hxc_ap_detail_links.time_building_block_id%type,
1477: p_detail_ovn in hxc_ap_detail_links.time_building_block_ovn%type) is
1478: select 'Y'
1479: from hxc_ap_detail_links adl,
1480: hxc_app_period_summary aps

Line 1477: p_detail_ovn in hxc_ap_detail_links.time_building_block_ovn%type) is

1473: ) return boolean is
1474:
1475: cursor c_detail_approved
1476: (p_detail_id in hxc_ap_detail_links.time_building_block_id%type,
1477: p_detail_ovn in hxc_ap_detail_links.time_building_block_ovn%type) is
1478: select 'Y'
1479: from hxc_ap_detail_links adl,
1480: hxc_app_period_summary aps
1481: where adl.time_building_block_id = p_detail_id

Line 1479: from hxc_ap_detail_links adl,

1475: cursor c_detail_approved
1476: (p_detail_id in hxc_ap_detail_links.time_building_block_id%type,
1477: p_detail_ovn in hxc_ap_detail_links.time_building_block_ovn%type) is
1478: select 'Y'
1479: from hxc_ap_detail_links adl,
1480: hxc_app_period_summary aps
1481: where adl.time_building_block_id = p_detail_id
1482: and adl.time_building_block_ovn = p_detail_ovn
1483: and adl.application_period_id = aps.application_period_id

Line 1486: from hxc_ap_detail_links adl2,

1482: and adl.time_building_block_ovn = p_detail_ovn
1483: and adl.application_period_id = aps.application_period_id
1484: and aps.approval_status = hxc_timecard.c_approved_status
1485: and not exists(select 1
1486: from hxc_ap_detail_links adl2,
1487: hxc_app_period_summary aps2
1488: where adl2.time_building_block_id = adl.time_building_block_id
1489: and adl2.time_building_block_ovn = adl.time_building_block_ovn
1490: and adl2.application_period_id <> adl.application_period_id