APPS.PAY_PAYGB45L_XMLP_PKG dependencies on PAY_GB_EOY_ARCHIVE

Line 29: select substr(pay_gb_eoy_archive.get_parameter

25: P_ACTION_RESTRICTION := 'AND act.payroll_action_id = '||P_PAYROLL_ACTION_ID;
26: else
27: P_ACTION_RESTRICTION := 'AND act.assignment_action_id = '||P_ASSIGNMENT_ACTION_ID;
28: end if;
29: select substr(pay_gb_eoy_archive.get_parameter
30: (p.legislative_parameters,'TAX_REF'),1,3),
31: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter
32: (p.legislative_parameters,'TAX_REF'),4,11),'/') ,1,10),
33: substr(pay_gb_eoy_archive.get_arch_str

Line 31: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter

27: P_ACTION_RESTRICTION := 'AND act.assignment_action_id = '||P_ASSIGNMENT_ACTION_ID;
28: end if;
29: select substr(pay_gb_eoy_archive.get_parameter
30: (p.legislative_parameters,'TAX_REF'),1,3),
31: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter
32: (p.legislative_parameters,'TAX_REF'),4,11),'/') ,1,10),
33: substr(pay_gb_eoy_archive.get_arch_str
34: (p.payroll_action_id,
35: 'X_EMPLOYERS_ADDRESS_LINE','0'),1,60),

Line 33: substr(pay_gb_eoy_archive.get_arch_str

29: select substr(pay_gb_eoy_archive.get_parameter
30: (p.legislative_parameters,'TAX_REF'),1,3),
31: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter
32: (p.legislative_parameters,'TAX_REF'),4,11),'/') ,1,10),
33: substr(pay_gb_eoy_archive.get_arch_str
34: (p.payroll_action_id,
35: 'X_EMPLOYERS_ADDRESS_LINE','0'),1,60),
36: substr(pay_gb_eoy_archive.get_arch_str
37: (p.payroll_action_id,

Line 36: substr(pay_gb_eoy_archive.get_arch_str

32: (p.legislative_parameters,'TAX_REF'),4,11),'/') ,1,10),
33: substr(pay_gb_eoy_archive.get_arch_str
34: (p.payroll_action_id,
35: 'X_EMPLOYERS_ADDRESS_LINE','0'),1,60),
36: substr(pay_gb_eoy_archive.get_arch_str
37: (p.payroll_action_id,
38: 'X_EMPLOYERS_NAME','0'),1,40)
39: into C_TAX_DIST_NO, C_TAX_DIST_REF, l_ers_address, C_ERS_NAME
40: from pay_payroll_actions p