DBA Data[Home] [Help]

APPS.HR_LEGISLATION dependencies on FND_LANGUAGES

Line 6648: FND_LANGUAGES L,

6644: BT.LAST_UPDATE_LOGIN,
6645: BT.CREATED_BY,
6646: BT.CREATION_DATE
6647: from PAY_BALANCE_TYPES BT,
6648: FND_LANGUAGES L,
6649: FND_LANGUAGES B
6650: where L.INSTALLED_FLAG in ('I', 'B')
6651: and B.INSTALLED_FLAG = 'B'
6652: and NVL(TO_CHAR(BT.BUSINESS_GROUP_ID),'Null Value')='Null Value'

Line 6649: FND_LANGUAGES B

6645: BT.CREATED_BY,
6646: BT.CREATION_DATE
6647: from PAY_BALANCE_TYPES BT,
6648: FND_LANGUAGES L,
6649: FND_LANGUAGES B
6650: where L.INSTALLED_FLAG in ('I', 'B')
6651: and B.INSTALLED_FLAG = 'B'
6652: and NVL(TO_CHAR(BT.BUSINESS_GROUP_ID),'Null Value')='Null Value'
6653: and (

Line 6764: FND_LANGUAGES L,

6760: EC.LAST_UPDATE_LOGIN,
6761: EC.CREATED_BY,
6762: EC.CREATION_DATE
6763: from PAY_ELEMENT_CLASSIFICATIONS EC,
6764: FND_LANGUAGES L,
6765: FND_LANGUAGES B
6766: where L.INSTALLED_FLAG in ('I', 'B')
6767: and B.INSTALLED_FLAG = 'B'
6768: and NVL(TO_CHAR(EC.BUSINESS_GROUP_ID),'Null Value')='Null Value'

Line 6765: FND_LANGUAGES B

6761: EC.CREATED_BY,
6762: EC.CREATION_DATE
6763: from PAY_ELEMENT_CLASSIFICATIONS EC,
6764: FND_LANGUAGES L,
6765: FND_LANGUAGES B
6766: where L.INSTALLED_FLAG in ('I', 'B')
6767: and B.INSTALLED_FLAG = 'B'
6768: and NVL(TO_CHAR(EC.BUSINESS_GROUP_ID),'Null Value')='Null Value'
6769: and

Line 6876: FND_LANGUAGES L,

6872: ET.LAST_UPDATE_LOGIN,
6873: ET.CREATED_BY,
6874: ET.CREATION_DATE
6875: from PAY_ELEMENT_TYPES_F ET,
6876: FND_LANGUAGES L,
6877: FND_LANGUAGES B
6878: where L.INSTALLED_FLAG in ('I', 'B')
6879: and B.INSTALLED_FLAG = 'B'
6880: and NVL(TO_CHAR(ET.BUSINESS_GROUP_ID),'Null Value')='Null Value'

Line 6877: FND_LANGUAGES B

6873: ET.CREATED_BY,
6874: ET.CREATION_DATE
6875: from PAY_ELEMENT_TYPES_F ET,
6876: FND_LANGUAGES L,
6877: FND_LANGUAGES B
6878: where L.INSTALLED_FLAG in ('I', 'B')
6879: and B.INSTALLED_FLAG = 'B'
6880: and NVL(TO_CHAR(ET.BUSINESS_GROUP_ID),'Null Value')='Null Value'
6881: and

Line 6999: FND_LANGUAGES L,

6995: IV.LAST_UPDATE_LOGIN,
6996: IV.CREATED_BY,
6997: IV.CREATION_DATE
6998: from PAY_INPUT_VALUES_F IV,
6999: FND_LANGUAGES L,
7000: FND_LANGUAGES B
7001: where L.INSTALLED_FLAG in ('I', 'B')
7002: and B.INSTALLED_FLAG = 'B'
7003: and NVL(TO_CHAR(IV.BUSINESS_GROUP_ID),'Null Value')='Null Value'

Line 7000: FND_LANGUAGES B

6996: IV.CREATED_BY,
6997: IV.CREATION_DATE
6998: from PAY_INPUT_VALUES_F IV,
6999: FND_LANGUAGES L,
7000: FND_LANGUAGES B
7001: where L.INSTALLED_FLAG in ('I', 'B')
7002: and B.INSTALLED_FLAG = 'B'
7003: and NVL(TO_CHAR(IV.BUSINESS_GROUP_ID),'Null Value')='Null Value'
7004: and not exists (

Line 7103: FND_LANGUAGES L,

7099: PT.LAST_UPDATE_LOGIN,
7100: PT.CREATED_BY,
7101: PT.CREATION_DATE
7102: from PAY_PAYMENT_TYPES PT,
7103: FND_LANGUAGES L,
7104: FND_LANGUAGES B
7105: where L.INSTALLED_FLAG in ('I', 'B')
7106: and B.INSTALLED_FLAG = 'B'
7107: and not exists (

Line 7104: FND_LANGUAGES B

7100: PT.CREATED_BY,
7101: PT.CREATION_DATE
7102: from PAY_PAYMENT_TYPES PT,
7103: FND_LANGUAGES L,
7104: FND_LANGUAGES B
7105: where L.INSTALLED_FLAG in ('I', 'B')
7106: and B.INSTALLED_FLAG = 'B'
7107: and not exists (
7108: select '1'

Line 7195: FND_LANGUAGES L,

7191: M.LAST_UPDATE_LOGIN,
7192: M.CREATED_BY,
7193: M.CREATION_DATE
7194: from PER_ASSIGNMENT_INFO_TYPES M,
7195: FND_LANGUAGES L,
7196: FND_LANGUAGES B
7197: where L.INSTALLED_FLAG in ('I', 'B')
7198: and B.INSTALLED_FLAG = 'B'
7199: and not exists ( select '1'

Line 7196: FND_LANGUAGES B

7192: M.CREATED_BY,
7193: M.CREATION_DATE
7194: from PER_ASSIGNMENT_INFO_TYPES M,
7195: FND_LANGUAGES L,
7196: FND_LANGUAGES B
7197: where L.INSTALLED_FLAG in ('I', 'B')
7198: and B.INSTALLED_FLAG = 'B'
7199: and not exists ( select '1'
7200: from per_assignment_info_types_tl pait

Line 7284: FND_LANGUAGES L,

7280: M.LAST_UPDATE_LOGIN,
7281: M.CREATED_BY,
7282: M.CREATION_DATE
7283: from PER_ASSIGNMENT_STATUS_TYPES M,
7284: FND_LANGUAGES L,
7285: FND_LANGUAGES B
7286: where L.INSTALLED_FLAG in ('I', 'B')
7287: and B.INSTALLED_FLAG = 'B'
7288: and NVL(TO_CHAR(M.BUSINESS_GROUP_ID),'Null Value')='Null Value'

Line 7285: FND_LANGUAGES B

7281: M.CREATED_BY,
7282: M.CREATION_DATE
7283: from PER_ASSIGNMENT_STATUS_TYPES M,
7284: FND_LANGUAGES L,
7285: FND_LANGUAGES B
7286: where L.INSTALLED_FLAG in ('I', 'B')
7287: and B.INSTALLED_FLAG = 'B'
7288: and NVL(TO_CHAR(M.BUSINESS_GROUP_ID),'Null Value')='Null Value'
7289: and not exists (

Line 7373: FND_LANGUAGES L,

7369: M.LAST_UPDATE_LOGIN,
7370: M.CREATED_BY,
7371: M.CREATION_DATE
7372: from PAY_MONETARY_UNITS M,
7373: FND_LANGUAGES L,
7374: FND_LANGUAGES B
7375: where L.INSTALLED_FLAG in ('I', 'B')
7376: and B.INSTALLED_FLAG = 'B'
7377: and NVL(TO_CHAR(M.BUSINESS_GROUP_ID),'Null Value')='Null Value'

Line 7374: FND_LANGUAGES B

7370: M.CREATED_BY,
7371: M.CREATION_DATE
7372: from PAY_MONETARY_UNITS M,
7373: FND_LANGUAGES L,
7374: FND_LANGUAGES B
7375: where L.INSTALLED_FLAG in ('I', 'B')
7376: and B.INSTALLED_FLAG = 'B'
7377: and NVL(TO_CHAR(M.BUSINESS_GROUP_ID),'Null Value')='Null Value'
7378: and not exists (

Line 7461: FND_LANGUAGES L,

7457: bc.LAST_UPDATE_LOGIN,
7458: bc.CREATED_BY,
7459: bc.CREATION_DATE
7460: from PAY_BALANCE_CATEGORIES_F bc,
7461: FND_LANGUAGES L,
7462: FND_LANGUAGES B
7463: where L.INSTALLED_FLAG in ('I', 'B')
7464: and B.INSTALLED_FLAG = 'B'
7465: and not exists (

Line 7462: FND_LANGUAGES B

7458: bc.CREATED_BY,
7459: bc.CREATION_DATE
7460: from PAY_BALANCE_CATEGORIES_F bc,
7461: FND_LANGUAGES L,
7462: FND_LANGUAGES B
7463: where L.INSTALLED_FLAG in ('I', 'B')
7464: and B.INSTALLED_FLAG = 'B'
7465: and not exists (
7466: select '1'