APPS.PAY_IE_WNU_EDI dependencies on PAY_PAYROLL_ACTIONS

Line 31: FROM pay_payroll_actions ppa

27: ('EMPLOYER_ADDRESS2=P') , nvl(trim(rpad(hlo.address_line_2,30)),' '),
28: ('EMPLOYER_ADDRESS3=P') , nvl(trim(rpad(hlo.address_line_3,30)),' '),
29: ('CONTACT_NAME=P') , nvl(trim(rpad(hoi.org_information4,20)),' '),
30: ('CONTACT_NUMBER=P') , nvl(trim(rpad(hlo.telephone_number_1,12)),' ')
31: FROM pay_payroll_actions ppa
32: ,hr_organization_units hou
33: ,hr_organization_information hoi
34: ,hr_locations_all hlo
35: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 68: pay_payroll_actions ppa,

64: upper('PAYROLL_NAME=P'),
65: nvl(ppayf.payroll_name ,' ')
66: from
67: pay_assignment_actions act,
68: pay_payroll_actions ppa,
69: per_all_assignments_f assign,
70: per_all_people_f people,
71: per_addresses pad,
72: pay_all_payrolls_f ppayf

Line 103: -- to return parameter values from legislative parameters in pay_payroll_actions

99: -- processing.
100: -- This procedure is used for both the P45 Archive process and the P45 EDI
101: -- process.
102: --
103: -- to return parameter values from legislative parameters in pay_payroll_actions
104: --
105: PROCEDURE range_cursor (pactid IN NUMBER,
106: sqlstr OUT NOCOPY VARCHAR2);
107: --