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.IGC_CC_OPEN_INTERFACE_PKG dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 383: FROM financials_system_parameters;

379: -- l_ap_purch_encmbrnc_type_id,
380: -- p_inv_encumbrance_type_id,
381: p_sb_prov_encmbrnc_flag,
382: p_sb_conf_encmbrnc_flag
383: FROM financials_system_parameters;
384:
385: /* IF l_ap_req_encmbrnc_type_id IS NOT NULL
386: THEN
387: p_req_encumbrance_type_id := l_ap_req_encmbrnc_type_id;

Line 3156: /* AND p.business_group_id = (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp) */

3152: AND sysdate BETWEEN NVL(fu.start_date, sysdate)
3153: AND NVL(fu.end_date, sysdate)
3154: AND fu.employee_id IS NOT NULL
3155: AND fu.employee_id = p.person_id
3156: /* AND p.business_group_id = (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp) */
3157: AND p.business_group_id = (Decode (FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP') , 'Y' , p.business_group_id , (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp)))
3158: AND p.employee_number is not null
3159: AND trunc(sysdate) between p.effective_start_date and p.effective_end_date
3160: AND a.person_id = p.person_id

Line 3157: AND p.business_group_id = (Decode (FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP') , 'Y' , p.business_group_id , (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp)))

3153: AND NVL(fu.end_date, sysdate)
3154: AND fu.employee_id IS NOT NULL
3155: AND fu.employee_id = p.person_id
3156: /* AND p.business_group_id = (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp) */
3157: AND p.business_group_id = (Decode (FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP') , 'Y' , p.business_group_id , (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp)))
3158: AND p.employee_number is not null
3159: AND trunc(sysdate) between p.effective_start_date and p.effective_end_date
3160: AND a.person_id = p.person_id
3161: AND a.primary_flag = 'Y'

Line 3206: /* AND p.business_group_id = (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp) */

3202: AND sysdate BETWEEN NVL(fu.start_date, sysdate)
3203: AND NVL(fu.end_date, sysdate)
3204: AND fu.employee_id IS NOT NULL
3205: AND fu.employee_id = p.person_id
3206: /* AND p.business_group_id = (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp) */
3207: AND p.business_group_id = (Decode (FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP') , 'Y' , p.business_group_id , (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp)))
3208: AND p.employee_number is not null
3209: AND trunc(sysdate) between p.effective_start_date and p.effective_end_date
3210: AND a.person_id = p.person_id

Line 3207: AND p.business_group_id = (Decode (FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP') , 'Y' , p.business_group_id , (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp)))

3203: AND NVL(fu.end_date, sysdate)
3204: AND fu.employee_id IS NOT NULL
3205: AND fu.employee_id = p.person_id
3206: /* AND p.business_group_id = (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp) */
3207: AND p.business_group_id = (Decode (FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP') , 'Y' , p.business_group_id , (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp)))
3208: AND p.employee_number is not null
3209: AND trunc(sysdate) between p.effective_start_date and p.effective_end_date
3210: AND a.person_id = p.person_id
3211: AND a.primary_flag = 'Y'

Line 3346: /* AND p.business_group_id = (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp) */

3342: AND sysdate BETWEEN NVL(fu.start_date, sysdate)
3343: AND NVL(fu.end_date, sysdate)
3344: AND fu.employee_id IS NOT NULL
3345: AND fu.employee_id = p.person_id
3346: /* AND p.business_group_id = (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp) */
3347: AND p.business_group_id = (Decode (FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP') , 'Y' , p.business_group_id , (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp)))
3348: AND p.employee_number is not null
3349: AND trunc(sysdate) between p.effective_start_date and p.effective_end_date
3350: AND a.person_id = p.person_id

Line 3347: AND p.business_group_id = (Decode (FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP') , 'Y' , p.business_group_id , (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp)))

3343: AND NVL(fu.end_date, sysdate)
3344: AND fu.employee_id IS NOT NULL
3345: AND fu.employee_id = p.person_id
3346: /* AND p.business_group_id = (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp) */
3347: AND p.business_group_id = (Decode (FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP') , 'Y' , p.business_group_id , (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp)))
3348: AND p.employee_number is not null
3349: AND trunc(sysdate) between p.effective_start_date and p.effective_end_date
3350: AND a.person_id = p.person_id
3351: AND a.primary_flag = 'Y'