APPS.AD_PATCH dependencies on FND_PRODUCT_GROUPS

Line 75: FND_PRODUCT_GROUPS fpg

71: then
72: begin
73: select s.snapshot_id into l_snapshot_id
74: from AD_SNAPSHOTS s, AD_APPL_TOPS a,
75: FND_PRODUCT_GROUPS fpg
76: where s.snapshot_name = GLOBAL_VIEW_SNP_NAME
77: and s.snapshot_type = 'G'
78: and s.appl_top_id = a.appl_top_id
79: and a.name = 'GLOBAL'

Line 172: FND_PRODUCT_GROUPS fpg

168: then
169: begin
170: select s.snapshot_id into l_snapshot_id
171: from AD_SNAPSHOTS s, AD_APPL_TOPS a,
172: FND_PRODUCT_GROUPS fpg
173: where s.snapshot_name = GLOBAL_VIEW_SNP_NAME
174: and s.snapshot_type = 'G'
175: and s.appl_top_id = a.appl_top_id
176: and a.name = 'GLOBAL'

Line 372: FND_PRODUCT_GROUPS fpg

368: then
369: begin
370: select s.snapshot_id into l_snapshot_id
371: from AD_SNAPSHOTS s, AD_APPL_TOPS a,
372: FND_PRODUCT_GROUPS fpg
373: where s.snapshot_name = GLOBAL_VIEW_SNP_NAME
374: and s.snapshot_type = 'G'
375: and s.appl_top_id = a.appl_top_id
376: and a.name = 'GLOBAL'

Line 847: FND_PRODUCT_GROUPS fpg

843: then
844: begin
845: select s.snapshot_id into l_snapshot_id
846: from AD_SNAPSHOTS s, AD_APPL_TOPS a,
847: FND_PRODUCT_GROUPS fpg
848: where s.snapshot_name = GLOBAL_VIEW_SNP_NAME
849: and s.snapshot_type = 'G'
850: and s.appl_top_id = a.appl_top_id
851: and a.name = 'GLOBAL'

Line 1000: FND_PRODUCT_GROUPS.

996: and optionally an Applications System name and/or APPL_TOP type.
997: 1. If APPL_TOP type not specified, it defaults to a normal APPL_TOP
998: i.e 'R'
999: 2. If Applications Sytem name not specified, it defaults to the value in
1000: FND_PRODUCT_GROUPS.
1001:
1002: *******************************************************************************/
1003:
1004: function getAppltopID(p_appl_top_name in varchar2,

Line 1021: from FND_PRODUCT_GROUPS;

1017: from dual;
1018:
1019: if ((upper(p_app_sys_name)) is null) then
1020: select applications_system_name into l_app_sys_name
1021: from FND_PRODUCT_GROUPS;
1022: else
1023: l_app_sys_name := p_app_sys_name;
1024: end if;
1025: