DBA Data[Home] [Help]

APPS.PAY_PAYGBP45_XMLP_PKG dependencies on PAY_GB_EOY_ARCHIVE

Line 32: SUBSTR(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(P.LEGISLATIVE_PARAMETERS

28: ELSE
29: P_ACTION_RESTRICTION := 'AND act.assignment_action_id = ' || P_ASSIGNMENT_ACTION_ID;
30: END IF;
31: SELECT
32: SUBSTR(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(P.LEGISLATIVE_PARAMETERS
33: ,'TAX_REF')
34: ,1
35: ,3),
36: SUBSTR(LTRIM(SUBSTR(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(P.LEGISLATIVE_PARAMETERS

Line 36: SUBSTR(LTRIM(SUBSTR(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(P.LEGISLATIVE_PARAMETERS

32: SUBSTR(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(P.LEGISLATIVE_PARAMETERS
33: ,'TAX_REF')
34: ,1
35: ,3),
36: SUBSTR(LTRIM(SUBSTR(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(P.LEGISLATIVE_PARAMETERS
37: ,'TAX_REF')
38: ,4
39: ,11)
40: ,'/')

Line 43: SUBSTR(PAY_GB_EOY_ARCHIVE.GET_ARCH_STR(P.PAYROLL_ACTION_ID

39: ,11)
40: ,'/')
41: ,1
42: ,10),
43: SUBSTR(PAY_GB_EOY_ARCHIVE.GET_ARCH_STR(P.PAYROLL_ACTION_ID
44: ,'X_EMPLOYERS_ADDRESS_LINE'
45: ,'0')
46: ,1
47: ,60),

Line 48: SUBSTR(PAY_GB_EOY_ARCHIVE.GET_ARCH_STR(P.PAYROLL_ACTION_ID

44: ,'X_EMPLOYERS_ADDRESS_LINE'
45: ,'0')
46: ,1
47: ,60),
48: SUBSTR(PAY_GB_EOY_ARCHIVE.GET_ARCH_STR(P.PAYROLL_ACTION_ID
49: ,'X_EMPLOYERS_NAME'
50: ,'0')
51: ,1
52: ,40)