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
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: ,'/')
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),
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)