DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_PROCESS_PVT dependencies on OKL_K_HEADERS

Line 1011: okl_k_headers khr

1007: khr.deal_type,
1008: khr.term_duration,
1009: NVL(khr.generate_accrual_yn, 'Y')
1010: FROM okc_k_headers_b chr,
1011: okl_k_headers khr
1012: WHERE khr.id = p_khr_id
1013: AND chr.id = khr.id;
1014:
1015: l_hdr c_hdr%ROWTYPE;

Line 1851: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;

1847: x_converted_amount OUT NOCOPY NUMBER,
1848: x_return_status OUT NOCOPY VARCHAR2) is
1849:
1850: l_contract_currency okc_k_headers_b.currency_code%TYPE;
1851: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;
1852: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;
1853: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;
1854: l_converted_subsidy_amount Number;
1855: l_rounded_subsidy_amount Number;

Line 1852: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;

1848: x_return_status OUT NOCOPY VARCHAR2) is
1849:
1850: l_contract_currency okc_k_headers_b.currency_code%TYPE;
1851: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;
1852: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;
1853: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;
1854: l_converted_subsidy_amount Number;
1855: l_rounded_subsidy_amount Number;
1856:

Line 1853: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;

1849:
1850: l_contract_currency okc_k_headers_b.currency_code%TYPE;
1851: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;
1852: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;
1853: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;
1854: l_converted_subsidy_amount Number;
1855: l_rounded_subsidy_amount Number;
1856:
1857: error_condition Exception;

Line 4311: FROM Okl_k_Headers khr,

4307: rgd.Id rgd_Id,
4308: cPl.Bill_To_Site_Use_Id Bill_To_Site_Use_Id,
4309: -- cPl.ROLE ParACty_Role,
4310: cPl.cUst_acct_Id cUst_acct_Id
4311: FROM Okl_k_Headers khr,
4312: Okc_k_Headers_b Par,
4313: Okc_Rule_Groups_v rgd,
4314: Okc_k_Party_Roles_b cPl
4315: WHERE khr.Id = cp_khr_Id