APPS.PER_JP_DEPENDENT_PKG dependencies on FND_GLOBAL

Line 567: -- fnd_global is better than fnd_profile.value. */

563: -- /* This relation is to fetch legislation code, ideally this should be parameter. */
564: where pcr.contact_relationship_id = pceif.contact_relationship_id
565: and pbg.business_group_id = pcr.business_group_id
566: -- /* This sql should be called by EBS, ideally these should be parameter.
567: -- fnd_global is better than fnd_profile.value. */
568: and pitsc.application_id = fnd_global.resp_appl_id
569: and pitsc.responsibility_id = fnd_global.resp_id
570: and pitsc.information_type = pceif.information_type
571: and pitsc.legislation_code = nvl(pbg.legislation_code,pitsc.legislation_code));

Line 568: and pitsc.application_id = fnd_global.resp_appl_id

564: where pcr.contact_relationship_id = pceif.contact_relationship_id
565: and pbg.business_group_id = pcr.business_group_id
566: -- /* This sql should be called by EBS, ideally these should be parameter.
567: -- fnd_global is better than fnd_profile.value. */
568: and pitsc.application_id = fnd_global.resp_appl_id
569: and pitsc.responsibility_id = fnd_global.resp_id
570: and pitsc.information_type = pceif.information_type
571: and pitsc.legislation_code = nvl(pbg.legislation_code,pitsc.legislation_code));
572: --

Line 569: and pitsc.responsibility_id = fnd_global.resp_id

565: and pbg.business_group_id = pcr.business_group_id
566: -- /* This sql should be called by EBS, ideally these should be parameter.
567: -- fnd_global is better than fnd_profile.value. */
568: and pitsc.application_id = fnd_global.resp_appl_id
569: and pitsc.responsibility_id = fnd_global.resp_id
570: and pitsc.information_type = pceif.information_type
571: and pitsc.legislation_code = nvl(pbg.legislation_code,pitsc.legislation_code));
572: --
573: celrec_extra_info_detail cel_extra_info_detail%ROWTYPE;