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_INDEX_AMOUNT_PKG dependencies on PN_INDEX_EXCLUDE_TERM_ALL

Line 896: -- 23-SEP-06 prabhakar o Modified the curosrs to fetch terms from pn_index_exclude_term_all

892: -- 19-SEP-05 piagrawa o Modified to pass org id to pn_mo_cache_utils.
893: -- get_profile_value
894: -- 14-AUG-06 pikhar o Added check to find out if contributing terms have
895: -- include_in_var_rent = 'INCLUDE_RI'
896: -- 23-SEP-06 prabhakar o Modified the curosrs to fetch terms from pn_index_exclude_term_all
897: -- with flag 'I' or from pn_payment_terms_all
898: -- 27-NOV-07 acprakas o Bug#6457105. Modified to consider new values for system option incl_terms_by_default_flag.
899: --------------------------------------------------------------------------------------------
900:

Line 950: FROM pn_index_exclude_term_all piet

946: AND ppt.start_date <= p_basis_end_date
947: AND ppt.frequency_code <> c_spread_frequency_one_time
948: AND (
949: ppt.payment_term_id IN (SELECT piet.payment_term_id
950: FROM pn_index_exclude_term_all piet
951: WHERE piet.index_lease_id = p_index_lease_id
952: AND piet.include_exclude_flag = 'I')
953: OR
954: (

Line 956: FROM pn_index_exclude_term_all piet

952: AND piet.include_exclude_flag = 'I')
953: OR
954: (
955: ppt.payment_term_id NOT IN (select piet.payment_term_id
956: FROM pn_index_exclude_term_all piet
957: WHERE piet.index_lease_id = p_index_lease_id)
958: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'Y' OR
959: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR
960: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')

Line 990: FROM pn_index_exclude_term_all piet

986: AND ppt.start_date <= p_basis_end_date
987: AND ppt.frequency_code <> c_spread_frequency_one_time
988: AND (
989: ppt.payment_term_id IN (SELECT piet.payment_term_id
990: FROM pn_index_exclude_term_all piet
991: WHERE piet.index_lease_id = p_index_lease_id
992: AND piet.include_exclude_flag = 'I')
993: OR
994: (

Line 996: FROM pn_index_exclude_term_all piet

992: AND piet.include_exclude_flag = 'I')
993: OR
994: (
995: ppt.payment_term_id NOT IN (select piet.payment_term_id
996: FROM pn_index_exclude_term_all piet
997: WHERE piet.index_lease_id = p_index_lease_id)
998: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'Y' OR
999: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR
1000: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')

Line 1028: FROM pn_index_exclude_term_all piet

1024: AND ppt.start_date <= p_basis_end_date
1025: AND ppt.frequency_code <> c_spread_frequency_one_time
1026: AND (
1027: ppt.payment_term_id IN (SELECT piet.payment_term_id
1028: FROM pn_index_exclude_term_all piet
1029: WHERE piet.index_lease_id = p_index_lease_id
1030: AND piet.include_exclude_flag = 'I')
1031: OR
1032: (

Line 1034: FROM pn_index_exclude_term_all piet

1030: AND piet.include_exclude_flag = 'I')
1031: OR
1032: (
1033: ppt.payment_term_id NOT IN (select piet.payment_term_id
1034: FROM pn_index_exclude_term_all piet
1035: WHERE piet.index_lease_id = p_index_lease_id)
1036: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'Y' OR
1037: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR
1038: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')

Line 1064: FROM pn_index_exclude_term_all piet

1060: AND ppt.start_date <= p_basis_end_date
1061: AND ppt.frequency_code <> c_spread_frequency_one_time
1062: AND (
1063: ppt.payment_term_id IN (SELECT piet.payment_term_id
1064: FROM pn_index_exclude_term_all piet
1065: WHERE piet.index_lease_id = p_index_lease_id
1066: AND piet.include_exclude_flag = 'I')
1067: OR
1068: (

Line 1070: FROM pn_index_exclude_term_all piet

1066: AND piet.include_exclude_flag = 'I')
1067: OR
1068: (
1069: ppt.payment_term_id NOT IN (select piet.payment_term_id
1070: FROM pn_index_exclude_term_all piet
1071: WHERE piet.index_lease_id = p_index_lease_id)
1072: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'Y' OR
1073: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR
1074: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')

Line 3022: FROM pn_index_exclude_term_all piet

3018: AND ppt.payment_term_type_code = decode(ip_type_code,c_increase_on_gross,
3019: ppt.payment_term_type_code,ip_type_code)
3020: AND (
3021: ppt.payment_term_id IN (SELECT piet.payment_term_id
3022: FROM pn_index_exclude_term_all piet
3023: WHERE piet.index_lease_id = p_index_lease_id
3024: AND piet.include_exclude_flag = 'I')
3025: OR
3026: (

Line 3028: FROM pn_index_exclude_term_all piet

3024: AND piet.include_exclude_flag = 'I')
3025: OR
3026: (
3027: ppt.payment_term_id NOT IN (select piet.payment_term_id
3028: FROM pn_index_exclude_term_all piet
3029: WHERE piet.index_lease_id = p_index_lease_id)
3030: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'Y' OR
3031: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR
3032: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')

Line 3090: FROM pn_index_exclude_term_all piet

3086: OR ip_distribution_string IS NULL
3087: )
3088: AND (
3089: ppt.payment_term_id IN (SELECT piet.payment_term_id
3090: FROM pn_index_exclude_term_all piet
3091: WHERE piet.index_lease_id = p_index_lease_id
3092: AND piet.include_exclude_flag = 'I')
3093: OR
3094: (

Line 3096: FROM pn_index_exclude_term_all piet

3092: AND piet.include_exclude_flag = 'I')
3093: OR
3094: (
3095: ppt.payment_term_id NOT IN (select piet.payment_term_id
3096: FROM pn_index_exclude_term_all piet
3097: WHERE piet.index_lease_id = p_index_lease_id)
3098: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'Y' OR
3099: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'G' and l_gross_flag = 'Y' ) OR
3100: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'U' and l_gross_flag = 'N' )

Line 7515: Delete pn_index_exclude_term_all

7511: BEGIN
7512:
7513: /* Delete from table pn_index_exclude_term */
7514:
7515: Delete pn_index_exclude_term_all
7516: where index_lease_id = p_index_lease_id;
7517:
7518: /* undo the periods */
7519: