DBA Data[Home] [Help]

APPS.PAY_PAYGBP45_A4_PKG dependencies on PAY_GB_EOY_ARCHIVE

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

53: ELSE
54: P_ACTION_RESTRICTION := 'AND act.assignment_action_id = ' || P_ASSIGNMENT_ACTION_ID;
55: END IF;
56: SELECT
57: SUBSTR(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(P.LEGISLATIVE_PARAMETERS
58: ,'TAX_REF')
59: ,1
60: ,3),
61: SUBSTR(LTRIM(SUBSTR(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(P.LEGISLATIVE_PARAMETERS

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

57: SUBSTR(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(P.LEGISLATIVE_PARAMETERS
58: ,'TAX_REF')
59: ,1
60: ,3),
61: SUBSTR(LTRIM(SUBSTR(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(P.LEGISLATIVE_PARAMETERS
62: ,'TAX_REF')
63: ,4
64: ,11)
65: ,'/')

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

64: ,11)
65: ,'/')
66: ,1
67: ,10),
68: SUBSTR(PAY_GB_EOY_ARCHIVE.GET_ARCH_STR(P.PAYROLL_ACTION_ID
69: ,'X_EMPLOYERS_ADDRESS_LINE'
70: ,'0')
71: ,1
72: ,60),

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

69: ,'X_EMPLOYERS_ADDRESS_LINE'
70: ,'0')
71: ,1
72: ,60),
73: SUBSTR(PAY_GB_EOY_ARCHIVE.GET_ARCH_STR(P.PAYROLL_ACTION_ID
74: ,'X_EMPLOYERS_NAME'
75: ,'0')
76: ,1
77: ,40)