DBA Data[Home] [Help]

APPS.HR_LEGISLATION dependencies on FND_LANGUAGES

Line 6898: FND_LANGUAGES L,

6894: BT.LAST_UPDATE_LOGIN,
6895: BT.CREATED_BY,
6896: BT.CREATION_DATE
6897: from PAY_BALANCE_TYPES BT,
6898: FND_LANGUAGES L,
6899: FND_LANGUAGES B
6900: where L.INSTALLED_FLAG in ('I', 'B')
6901: and B.INSTALLED_FLAG = 'B'
6902: and NVL(TO_CHAR(BT.BUSINESS_GROUP_ID),'Null Value')='Null Value'

Line 6899: FND_LANGUAGES B

6895: BT.CREATED_BY,
6896: BT.CREATION_DATE
6897: from PAY_BALANCE_TYPES BT,
6898: FND_LANGUAGES L,
6899: FND_LANGUAGES B
6900: where L.INSTALLED_FLAG in ('I', 'B')
6901: and B.INSTALLED_FLAG = 'B'
6902: and NVL(TO_CHAR(BT.BUSINESS_GROUP_ID),'Null Value')='Null Value'
6903: and (

Line 7014: FND_LANGUAGES L,

7010: EC.LAST_UPDATE_LOGIN,
7011: EC.CREATED_BY,
7012: EC.CREATION_DATE
7013: from PAY_ELEMENT_CLASSIFICATIONS EC,
7014: FND_LANGUAGES L,
7015: FND_LANGUAGES B
7016: where L.INSTALLED_FLAG in ('I', 'B')
7017: and B.INSTALLED_FLAG = 'B'
7018: and NVL(TO_CHAR(EC.BUSINESS_GROUP_ID),'Null Value')='Null Value'

Line 7015: FND_LANGUAGES B

7011: EC.CREATED_BY,
7012: EC.CREATION_DATE
7013: from PAY_ELEMENT_CLASSIFICATIONS EC,
7014: FND_LANGUAGES L,
7015: FND_LANGUAGES B
7016: where L.INSTALLED_FLAG in ('I', 'B')
7017: and B.INSTALLED_FLAG = 'B'
7018: and NVL(TO_CHAR(EC.BUSINESS_GROUP_ID),'Null Value')='Null Value'
7019: and

Line 7126: FND_LANGUAGES L,

7122: ET.LAST_UPDATE_LOGIN,
7123: ET.CREATED_BY,
7124: ET.CREATION_DATE
7125: from PAY_ELEMENT_TYPES_F ET,
7126: FND_LANGUAGES L,
7127: FND_LANGUAGES B
7128: where L.INSTALLED_FLAG in ('I', 'B')
7129: and B.INSTALLED_FLAG = 'B'
7130: and NVL(TO_CHAR(ET.BUSINESS_GROUP_ID),'Null Value')='Null Value'

Line 7127: FND_LANGUAGES B

7123: ET.CREATED_BY,
7124: ET.CREATION_DATE
7125: from PAY_ELEMENT_TYPES_F ET,
7126: FND_LANGUAGES L,
7127: FND_LANGUAGES B
7128: where L.INSTALLED_FLAG in ('I', 'B')
7129: and B.INSTALLED_FLAG = 'B'
7130: and NVL(TO_CHAR(ET.BUSINESS_GROUP_ID),'Null Value')='Null Value'
7131: and

Line 7249: FND_LANGUAGES L,

7245: IV.LAST_UPDATE_LOGIN,
7246: IV.CREATED_BY,
7247: IV.CREATION_DATE
7248: from PAY_INPUT_VALUES_F IV,
7249: FND_LANGUAGES L,
7250: FND_LANGUAGES B
7251: where L.INSTALLED_FLAG in ('I', 'B')
7252: and B.INSTALLED_FLAG = 'B'
7253: and NVL(TO_CHAR(IV.BUSINESS_GROUP_ID),'Null Value')='Null Value'

Line 7250: FND_LANGUAGES B

7246: IV.CREATED_BY,
7247: IV.CREATION_DATE
7248: from PAY_INPUT_VALUES_F IV,
7249: FND_LANGUAGES L,
7250: FND_LANGUAGES B
7251: where L.INSTALLED_FLAG in ('I', 'B')
7252: and B.INSTALLED_FLAG = 'B'
7253: and NVL(TO_CHAR(IV.BUSINESS_GROUP_ID),'Null Value')='Null Value'
7254: and not exists (

Line 7353: FND_LANGUAGES L,

7349: PT.LAST_UPDATE_LOGIN,
7350: PT.CREATED_BY,
7351: PT.CREATION_DATE
7352: from PAY_PAYMENT_TYPES PT,
7353: FND_LANGUAGES L,
7354: FND_LANGUAGES B
7355: where L.INSTALLED_FLAG in ('I', 'B')
7356: and B.INSTALLED_FLAG = 'B'
7357: and not exists (

Line 7354: FND_LANGUAGES B

7350: PT.CREATED_BY,
7351: PT.CREATION_DATE
7352: from PAY_PAYMENT_TYPES PT,
7353: FND_LANGUAGES L,
7354: FND_LANGUAGES B
7355: where L.INSTALLED_FLAG in ('I', 'B')
7356: and B.INSTALLED_FLAG = 'B'
7357: and not exists (
7358: select '1'

Line 7445: FND_LANGUAGES L,

7441: M.LAST_UPDATE_LOGIN,
7442: M.CREATED_BY,
7443: M.CREATION_DATE
7444: from PER_ASSIGNMENT_INFO_TYPES M,
7445: FND_LANGUAGES L,
7446: FND_LANGUAGES B
7447: where L.INSTALLED_FLAG in ('I', 'B')
7448: and B.INSTALLED_FLAG = 'B'
7449: and not exists ( select '1'

Line 7446: FND_LANGUAGES B

7442: M.CREATED_BY,
7443: M.CREATION_DATE
7444: from PER_ASSIGNMENT_INFO_TYPES M,
7445: FND_LANGUAGES L,
7446: FND_LANGUAGES B
7447: where L.INSTALLED_FLAG in ('I', 'B')
7448: and B.INSTALLED_FLAG = 'B'
7449: and not exists ( select '1'
7450: from per_assignment_info_types_tl pait

Line 7534: FND_LANGUAGES L,

7530: M.LAST_UPDATE_LOGIN,
7531: M.CREATED_BY,
7532: M.CREATION_DATE
7533: from PER_ASSIGNMENT_STATUS_TYPES M,
7534: FND_LANGUAGES L,
7535: FND_LANGUAGES B
7536: where L.INSTALLED_FLAG in ('I', 'B')
7537: and B.INSTALLED_FLAG = 'B'
7538: and NVL(TO_CHAR(M.BUSINESS_GROUP_ID),'Null Value')='Null Value'

Line 7535: FND_LANGUAGES B

7531: M.CREATED_BY,
7532: M.CREATION_DATE
7533: from PER_ASSIGNMENT_STATUS_TYPES M,
7534: FND_LANGUAGES L,
7535: FND_LANGUAGES B
7536: where L.INSTALLED_FLAG in ('I', 'B')
7537: and B.INSTALLED_FLAG = 'B'
7538: and NVL(TO_CHAR(M.BUSINESS_GROUP_ID),'Null Value')='Null Value'
7539: and not exists (

Line 7623: FND_LANGUAGES L,

7619: M.LAST_UPDATE_LOGIN,
7620: M.CREATED_BY,
7621: M.CREATION_DATE
7622: from PAY_MONETARY_UNITS M,
7623: FND_LANGUAGES L,
7624: FND_LANGUAGES B
7625: where L.INSTALLED_FLAG in ('I', 'B')
7626: and B.INSTALLED_FLAG = 'B'
7627: and NVL(TO_CHAR(M.BUSINESS_GROUP_ID),'Null Value')='Null Value'

Line 7624: FND_LANGUAGES B

7620: M.CREATED_BY,
7621: M.CREATION_DATE
7622: from PAY_MONETARY_UNITS M,
7623: FND_LANGUAGES L,
7624: FND_LANGUAGES B
7625: where L.INSTALLED_FLAG in ('I', 'B')
7626: and B.INSTALLED_FLAG = 'B'
7627: and NVL(TO_CHAR(M.BUSINESS_GROUP_ID),'Null Value')='Null Value'
7628: and not exists (

Line 7711: FND_LANGUAGES L,

7707: bc.LAST_UPDATE_LOGIN,
7708: bc.CREATED_BY,
7709: bc.CREATION_DATE
7710: from PAY_BALANCE_CATEGORIES_F bc,
7711: FND_LANGUAGES L,
7712: FND_LANGUAGES B
7713: where L.INSTALLED_FLAG in ('I', 'B')
7714: and B.INSTALLED_FLAG = 'B'
7715: and not exists (

Line 7712: FND_LANGUAGES B

7708: bc.CREATED_BY,
7709: bc.CREATION_DATE
7710: from PAY_BALANCE_CATEGORIES_F bc,
7711: FND_LANGUAGES L,
7712: FND_LANGUAGES B
7713: where L.INSTALLED_FLAG in ('I', 'B')
7714: and B.INSTALLED_FLAG = 'B'
7715: and not exists (
7716: select '1'