APPS.OTA_TFH_API_BUSINESS_RULES dependencies on OTA_FINANCE_HEADERS

Line 969: from ota_finance_headers

965: to_segment29,
966: to_segment30,
967: transfer_from_cc_id,
968: transfer_to_cc_id
969: from ota_finance_headers
970: where finance_header_id = p_finance_header_id ;
971: --
972: Begin
973: --

Line 1025: from ota_finance_headers tfh

1021: v_proc varchar2(72) := g_package||'check_superceding';
1022: --
1023: cursor sel_for_deletion is
1024: select 'Y'
1025: from ota_finance_headers tfh
1026: where tfh.superceding_header_id = p_finance_header_id;
1027: --
1028: Begin
1029: hr_utility.set_location('Entering:'|| v_proc, 5);

Line 1066: v_rec_header ota_finance_headers%rowtype;

1062: ,p_validate in boolean
1063: ,p_commit in boolean default FALSE
1064: ) is
1065: --
1066: v_rec_header ota_finance_headers%rowtype;
1067: l_rec_cancel ota_tfh_api_shd.g_rec_type;
1068: v_proc varchar2(72) := g_package||'recancel_header';
1069: --
1070: cursor sel_finance_header is

Line 1072: from ota_finance_headers tfh

1068: v_proc varchar2(72) := g_package||'recancel_header';
1069: --
1070: cursor sel_finance_header is
1071: select *
1072: from ota_finance_headers tfh
1073: where tfh.finance_header_id = p_finance_header_id;
1074: --
1075: Begin
1076: hr_utility.set_location('Entering:'|| v_proc, 5);

Line 1235: from ota_finance_headers tfh

1231: v_proc varchar2(72) := g_package||'check_superseded_header';
1232: --
1233: cursor sel_superseding_header is
1234: select 'Y'
1235: from ota_finance_headers tfh
1236: where tfh.finance_header_id = p_superseding_header_id;
1237: --
1238: --
1239: Begin

Line 1623: from ota_finance_headers tfh

1619: , to_segment29
1620: , to_segment30
1621: , transfer_from_cc_id
1622: , transfer_to_cc_id
1623: from ota_finance_headers tfh
1624: where tfh.finance_header_id = p_finance_header_id;
1625: --
1626: Begin
1627: --

Line 2258: from ota_finance_headers tfh

2254: cursor sel_for_deletion is
2255: select tfh.transfer_status
2256: , tfh.superceding_header_id
2257: , tfh.type
2258: from ota_finance_headers tfh
2259: where tfh.finance_header_id = p_finance_header_id;
2260: --
2261: Begin
2262: --

Line 2482: from ota_finance_headers

2478: l_dummy varchar2(1);
2479: --
2480: cursor get_superseding_header is
2481: select null
2482: from ota_finance_headers
2483: where superceding_header_id = p_finance_header_id;
2484: --
2485: begin
2486: hr_utility.set_location('Entering:'|| v_proc, 5);