APPS.PQH_FR_UTILITY dependencies on PER_CONTRACTS_F

Line 742: from per_contracts_f

738: Function Get_contract_reference(p_contract_id in Number, p_effective_date in Date) return varchar2
739: IS
740: Cursor csr_contract_ref IS
741: Select Reference
742: from per_contracts_f
743: where contract_id = p_contract_id
744: and p_effective_date between effective_start_date and effective_end_date;
745: --
746: l_contract_reference varchar2(240) := null;

Line 1410: FROM per_contracts_f

1406: --Cursor to fetch duration and extension details for the Contract
1407: CURSOR csr_contract_dtls IS
1408: SELECT status, duration, duration_units,
1409: extension_period, extension_period_units, number_of_extensions
1410: FROM per_contracts_f
1411: WHERE contract_id = NVL(p_contract_id,-1)
1412: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1413:
1414: --Variable Declaration.

Line 1415: l_status PER_CONTRACTS_F.status%TYPE;

1411: WHERE contract_id = NVL(p_contract_id,-1)
1412: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1413:
1414: --Variable Declaration.
1415: l_status PER_CONTRACTS_F.status%TYPE;
1416: l_duration PER_CONTRACTS_F.duration%TYPE;
1417: l_duration_units PER_CONTRACTS_F.duration_units%TYPE;
1418: l_extension PER_CONTRACTS_F.extension_period%TYPE;
1419: l_extension_units PER_CONTRACTS_F.extension_period_units%TYPE;

Line 1416: l_duration PER_CONTRACTS_F.duration%TYPE;

1412: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1413:
1414: --Variable Declaration.
1415: l_status PER_CONTRACTS_F.status%TYPE;
1416: l_duration PER_CONTRACTS_F.duration%TYPE;
1417: l_duration_units PER_CONTRACTS_F.duration_units%TYPE;
1418: l_extension PER_CONTRACTS_F.extension_period%TYPE;
1419: l_extension_units PER_CONTRACTS_F.extension_period_units%TYPE;
1420: l_no_of_extensions PER_CONTRACTS_F.number_of_extensions%TYPE;

Line 1417: l_duration_units PER_CONTRACTS_F.duration_units%TYPE;

1413:
1414: --Variable Declaration.
1415: l_status PER_CONTRACTS_F.status%TYPE;
1416: l_duration PER_CONTRACTS_F.duration%TYPE;
1417: l_duration_units PER_CONTRACTS_F.duration_units%TYPE;
1418: l_extension PER_CONTRACTS_F.extension_period%TYPE;
1419: l_extension_units PER_CONTRACTS_F.extension_period_units%TYPE;
1420: l_no_of_extensions PER_CONTRACTS_F.number_of_extensions%TYPE;
1421: l_start_date DATE;

Line 1418: l_extension PER_CONTRACTS_F.extension_period%TYPE;

1414: --Variable Declaration.
1415: l_status PER_CONTRACTS_F.status%TYPE;
1416: l_duration PER_CONTRACTS_F.duration%TYPE;
1417: l_duration_units PER_CONTRACTS_F.duration_units%TYPE;
1418: l_extension PER_CONTRACTS_F.extension_period%TYPE;
1419: l_extension_units PER_CONTRACTS_F.extension_period_units%TYPE;
1420: l_no_of_extensions PER_CONTRACTS_F.number_of_extensions%TYPE;
1421: l_start_date DATE;
1422: l_proposed_end_date DATE;

Line 1419: l_extension_units PER_CONTRACTS_F.extension_period_units%TYPE;

1415: l_status PER_CONTRACTS_F.status%TYPE;
1416: l_duration PER_CONTRACTS_F.duration%TYPE;
1417: l_duration_units PER_CONTRACTS_F.duration_units%TYPE;
1418: l_extension PER_CONTRACTS_F.extension_period%TYPE;
1419: l_extension_units PER_CONTRACTS_F.extension_period_units%TYPE;
1420: l_no_of_extensions PER_CONTRACTS_F.number_of_extensions%TYPE;
1421: l_start_date DATE;
1422: l_proposed_end_date DATE;
1423: --

Line 1420: l_no_of_extensions PER_CONTRACTS_F.number_of_extensions%TYPE;

1416: l_duration PER_CONTRACTS_F.duration%TYPE;
1417: l_duration_units PER_CONTRACTS_F.duration_units%TYPE;
1418: l_extension PER_CONTRACTS_F.extension_period%TYPE;
1419: l_extension_units PER_CONTRACTS_F.extension_period_units%TYPE;
1420: l_no_of_extensions PER_CONTRACTS_F.number_of_extensions%TYPE;
1421: l_start_date DATE;
1422: l_proposed_end_date DATE;
1423: --
1424: BEGIN