DBA Data[Home] [Help]

APPS.GCS_INTERCO_PROCESSING_PKG dependencies on GCS_INTERCO_RULES_TL

Line 1921: GCS_INTERCO_RULES_TL girt,

1917: MAX(SYSDATE), MAX(g_fnd_user_id),
1918: MAX(SYSDATE), MAX(g_fnd_user_id),
1919: MAX(g_fnd_login_id), 'N'
1920: FROM GCS_INTERCO_HDR_GT gehg,
1921: GCS_INTERCO_RULES_TL girt,
1922: GCS_ENTRY_LINES giet
1923: WHERE gehg.entry_id = entries.entry_id
1924: AND gehg.rule_id = girt.rule_id
1925: AND girt.language = USERENV('LANG')

Line 1990: GCS_INTERCO_RULES_TL girt

1986: SYSDATE, g_fnd_user_id,
1987: SYSDATE, g_fnd_user_id,
1988: g_fnd_login_id, 'N'
1989: FROM GCS_INTERCO_HDR_GT gehg,
1990: GCS_INTERCO_RULES_TL girt
1991: WHERE gehg.entry_id = entries.entry_id
1992: AND gehg.rule_id = girt.rule_id
1993: AND girt.language = USERENV('LANG');
1994:

Line 2064: GCS_INTERCO_RULES_TL girt

2060: SYSDATE, g_fnd_user_id,
2061: SYSDATE, g_fnd_user_id,
2062: g_fnd_login_id, 'N'
2063: FROM GCS_INTERCO_HDR_GT gehg,
2064: GCS_INTERCO_RULES_TL girt
2065: WHERE gehg.entry_id = entries.entry_id
2066: AND gehg.rule_id = girt.rule_id
2067: AND girt.language = USERENV('LANG');
2068:

Line 2139: GCS_INTERCO_RULES_TL girt,

2135: MAX(SYSDATE), MAX(g_fnd_user_id),
2136: MAX(SYSDATE), MAX(g_fnd_user_id),
2137: MAX(g_fnd_login_id), 'N'
2138: FROM GCS_INTERCO_HDR_GT gehg,
2139: GCS_INTERCO_RULES_TL girt,
2140: GCS_ENTRY_LINES giet
2141: WHERE (gehg.currency_code = P_currency_code
2142: AND gehg.threshold_currency = P_currency_code)
2143: AND gehg.rule_id = girt.rule_id

Line 2206: GCS_INTERCO_RULES_TL girt

2202: SYSDATE, g_fnd_user_id,
2203: g_fnd_login_id, 'N'
2204: FROM GCS_INTERCO_HDR_GT gehg,
2205: GCS_ENTRY_LINES gel,
2206: GCS_INTERCO_RULES_TL girt
2207: WHERE gehg.entry_id = gel.entry_id
2208: AND gehg.currency_code = 'STAT'
2209: AND gehg.rule_id = girt.rule_id
2210: AND girt.language = USERENV('LANG')