eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_LEASE_PVT dependencies on PN_DISTRIBUTIONS_ALL

Line 13564: FROM pn_distributions_all pda

13560:
13561: CURSOR cur_dist_details(l_term_id NUMBER,l_acc_code VARCHAR2)
13562: IS
13563: SELECT rowid row_id,rownum row_num,pda.*
13564: FROM pn_distributions_all pda
13565: WHERE pda.payment_term_id = l_term_id
13566: AND pda.account_class = l_acc_code
13567: AND pda.org_id = g_org_id
13568: AND rownum = 1;

Line 13600: FROM pn_distributions_all pda

13596:
13597: BEGIN
13598: SELECT max(rownum)
13599: INTO l_max_rownum
13600: FROM pn_distributions_all pda
13601: WHERE pda.payment_term_id = l_term_id;
13602: --AND pda.org_id = g_org_id;
13603: EXCEPTION
13604: WHEN OTHERS THEN

Line 13614: FROM pn_distributions_all

13610:
13611: begin
13612: SELECT count(1)
13613: INTO l_record_count
13614: FROM pn_distributions_all
13615: WHERE payment_term_id = l_term_id
13616: AND account_class = l_acc_code
13617: AND org_id = g_org_id;
13618: EXCEPTION

Line 14253: FROM pn_distributions_all pda

14249:
14250: CURSOR cur_dist_details(l_term_id NUMBER,l_acc_code VARCHAR2)
14251: IS
14252: SELECT rowid row_id,rownum row_num,pda.*
14253: FROM pn_distributions_all pda
14254: WHERE pda.payment_term_id = l_term_id
14255: AND pda.account_class = l_acc_code
14256: AND pda.org_id = g_org_id
14257: AND rownum = 1;

Line 14293: from pn_distributions_all

14289:
14290: CURSOR exp_rev_account_cur(l_term_template_id NUMBER,l_account_class VARCHAR2)
14291: is
14292: select account_id,percentage
14293: from pn_distributions_all
14294: where term_template_id = l_term_template_id
14295: and account_class = l_account_class
14296: and payment_term_id is null; --Bug 16423198
14297:

Line 14298: l_account_code pn_distributions_all.account_class%TYPE; --Bug16423198

14294: where term_template_id = l_term_template_id
14295: and account_class = l_account_class
14296: and payment_term_id is null; --Bug 16423198
14297:
14298: l_account_code pn_distributions_all.account_class%TYPE; --Bug16423198
14299: l_act_count number;--Bug16423198
14300:
14301:
14302: BEGIN

Line 15767: FROM pn_distributions_all

15763:
15764: BEGIN
15765: SELECT account_id,percentage
15766: INTO p_payment_terms_tbl(i).p_terms_exp_rev_accounts_tbl(1).account_id,p_payment_terms_tbl(i).p_terms_exp_rev_accounts_tbl(1).account_percentage
15767: FROM pn_distributions_all
15768: WHERE term_template_id = p_payment_terms_tbl(i).term_template_id
15769: AND account_class = p_payment_terms_tbl(i).p_terms_exp_rev_accounts_tbl(1).account_code
15770: AND payment_term_id IS NULL;
15771:

Line 15926: FROM pn_distributions_all

15922: END IF;
15923: BEGIN
15924: SELECT account_id,percentage
15925: INTO p_payment_terms_tbl(i).p_terms_liab_rcvl_account_tbl(1).account_id,p_payment_terms_tbl(i).p_terms_liab_rcvl_account_tbl(1).account_percentage
15926: FROM pn_distributions_all
15927: WHERE term_template_id = p_payment_terms_tbl(i).term_template_id
15928: AND account_class = p_payment_terms_tbl(i).p_terms_liab_rcvl_account_tbl(1).account_code
15929: AND payment_term_id IS NULL;
15930:

Line 16061: FROM pn_distributions_all

16057: END IF;
16058: BEGIN
16059: SELECT account_id,percentage
16060: INTO p_payment_terms_tbl(i).p_terms_accrual_account_tbl(1).account_id,p_payment_terms_tbl(i).p_terms_accrual_account_tbl(1).account_percentage
16061: FROM pn_distributions_all
16062: WHERE term_template_id = p_payment_terms_tbl(i).term_template_id
16063: AND account_class = p_payment_terms_tbl(i).p_terms_accrual_account_tbl(1).account_code
16064: AND payment_term_id IS NULL;
16065: EXCEPTION

Line 16275: FROM pn_distributions_all pda

16271: pvt_debug(g_pkg_name||'-VALIDATE_PAYMENT_TERMS_TBL:Before Account Update Account Check',3);
16272: BEGIN
16273: SELECT max(rownum)
16274: INTO l_max_rownum
16275: FROM pn_distributions_all pda
16276: WHERE pda.payment_term_id = p_payment_terms_tbl(i).payment_term_id
16277: AND pda.org_id = g_org_id;
16278: EXCEPTION
16279: WHEN OTHERS THEN

Line 16290: FROM pn_distributions_all

16286:
16287: BEGIN
16288: SELECT count(1)
16289: INTO l_record_count_exp_rev
16290: FROM pn_distributions_all
16291: WHERE payment_term_id = p_payment_terms_tbl(i).payment_term_id
16292: AND account_class = l_acc_code
16293: AND org_id = g_org_id;
16294: EXCEPTION

Line 16401: FROM pn_distributions_all

16397: pvt_debug(g_pkg_name||'-VALIDATE_PAYMENT_TERMS_TBL:Receiavable-Liability Account:'||l_acc_code||'-'||p_payment_terms_tbl(i).payment_term_id||'-'||g_org_id,3);
16398: BEGIN
16399: SELECT COUNT(1)
16400: INTO l_lia_exist_count
16401: FROM pn_distributions_all
16402: WHERE account_class = l_acc_code
16403: AND payment_term_id = p_payment_terms_tbl(i).payment_term_id
16404: AND org_id = g_org_id;
16405: pvt_debug(g_pkg_name||'-VALIDATE_PAYMENT_TERMS_TBL:Receivable/Liability Account Class Count:'||l_lia_exist_count,3);

Line 16459: DELETE FROM pn_distributions_all

16455: END;
16456: ELSE
16457: IF(p_lease_class_code = 'DIRECT') THEN
16458: BEGIN
16459: DELETE FROM pn_distributions_all
16460: WHERE account_class = l_acc_code
16461: AND payment_term_id = p_payment_terms_tbl(i).payment_term_id
16462: AND org_id = g_org_id;
16463: COMMIT;

Line 16543: FROM pn_distributions_all

16539: pvt_debug(g_pkg_name||'-VALIDATE_PAYMENT_TERMS_TBL:Accrual Account Class'||l_acc_code||'-'||p_payment_terms_tbl(i).payment_term_id||'-'||g_org_id,3);
16540: BEGIN
16541: SELECT COUNT(1)
16542: INTO l_acc_exist_count
16543: FROM pn_distributions_all
16544: WHERE account_class = l_acc_code
16545: AND payment_term_id = p_payment_terms_tbl(i).payment_term_id
16546: AND org_id = g_org_id;
16547: pvt_debug(g_pkg_name||'-VALIDATE_PAYMENT_TERMS_TBL:Accrual Account Class Count:'||l_acc_exist_count,3);

Line 16601: DELETE FROM pn_distributions_all

16597: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.UPDATE_ROW for Accrual:Exception:'||SQLERRM,3);
16598: END;
16599: ELSE
16600: BEGIN
16601: DELETE FROM pn_distributions_all
16602: WHERE account_class = l_acc_code
16603: AND payment_term_id = p_payment_terms_tbl(i).payment_term_id
16604: AND org_id = g_org_id;
16605:

Line 16738: FROM pn_distributions_all

16734:
16735: CURSOR cur_dist_details(p_payment_term_id NUMBER)
16736: IS
16737: SELECT *
16738: FROM pn_distributions_all
16739: WHERE payment_term_id = p_payment_term_id;
16740:
16741:
16742: -- l_payterm_details cur_payment_terms%ROWTYPE;