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 897: -- 23-SEP-06 prabhakar o Modified the curosrs to fetch terms from pn_index_exclude_term_all

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

Line 951: FROM pn_index_exclude_term_all piet

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

Line 957: FROM pn_index_exclude_term_all piet

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

Line 991: FROM pn_index_exclude_term_all piet

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

Line 997: FROM pn_index_exclude_term_all piet

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

Line 1029: FROM pn_index_exclude_term_all piet

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

Line 1035: FROM pn_index_exclude_term_all piet

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

Line 1065: FROM pn_index_exclude_term_all piet

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

Line 1071: FROM pn_index_exclude_term_all piet

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

Line 3023: FROM pn_index_exclude_term_all piet

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

Line 3029: FROM pn_index_exclude_term_all piet

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

Line 3091: FROM pn_index_exclude_term_all piet

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

Line 3097: FROM pn_index_exclude_term_all piet

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

Line 7517: Delete pn_index_exclude_term_all

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