APPS.PAY_US_W2C_RPT dependencies on PAY_US_PAYROLL_UTILS

Line 134: pay_us_payroll_utils.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),

130: )
131: IS
132: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
133: select
134: pay_us_payroll_utils.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),
135: pay_us_payroll_utils.get_parameter('PER_ID',ppa.legislative_parameters),
136: pay_us_payroll_utils.get_parameter('ASG_SET',ppa.legislative_parameters),
137: pay_us_payroll_utils.get_parameter('PRINT',ppa.legislative_parameters),
138: effective_date,

Line 135: pay_us_payroll_utils.get_parameter('PER_ID',ppa.legislative_parameters),

131: IS
132: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
133: select
134: pay_us_payroll_utils.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),
135: pay_us_payroll_utils.get_parameter('PER_ID',ppa.legislative_parameters),
136: pay_us_payroll_utils.get_parameter('ASG_SET',ppa.legislative_parameters),
137: pay_us_payroll_utils.get_parameter('PRINT',ppa.legislative_parameters),
138: effective_date,
139: start_date,

Line 136: pay_us_payroll_utils.get_parameter('ASG_SET',ppa.legislative_parameters),

132: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
133: select
134: pay_us_payroll_utils.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),
135: pay_us_payroll_utils.get_parameter('PER_ID',ppa.legislative_parameters),
136: pay_us_payroll_utils.get_parameter('ASG_SET',ppa.legislative_parameters),
137: pay_us_payroll_utils.get_parameter('PRINT',ppa.legislative_parameters),
138: effective_date,
139: start_date,
140: business_group_id,

Line 137: pay_us_payroll_utils.get_parameter('PRINT',ppa.legislative_parameters),

133: select
134: pay_us_payroll_utils.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),
135: pay_us_payroll_utils.get_parameter('PER_ID',ppa.legislative_parameters),
136: pay_us_payroll_utils.get_parameter('ASG_SET',ppa.legislative_parameters),
137: pay_us_payroll_utils.get_parameter('PRINT',ppa.legislative_parameters),
138: effective_date,
139: start_date,
140: business_group_id,
141: pay_us_payroll_utils.get_parameter('S1',ppa.legislative_parameters),

Line 141: pay_us_payroll_utils.get_parameter('S1',ppa.legislative_parameters),

137: pay_us_payroll_utils.get_parameter('PRINT',ppa.legislative_parameters),
138: effective_date,
139: start_date,
140: business_group_id,
141: pay_us_payroll_utils.get_parameter('S1',ppa.legislative_parameters),
142: pay_us_payroll_utils.get_parameter('S2',ppa.legislative_parameters),
143: pay_us_payroll_utils.get_parameter('S3',ppa.legislative_parameters),
144: to_date(pay_us_payroll_utils.get_parameter('EFFECTIVE_DATE',
145: ppa.legislative_parameters)

Line 142: pay_us_payroll_utils.get_parameter('S2',ppa.legislative_parameters),

138: effective_date,
139: start_date,
140: business_group_id,
141: pay_us_payroll_utils.get_parameter('S1',ppa.legislative_parameters),
142: pay_us_payroll_utils.get_parameter('S2',ppa.legislative_parameters),
143: pay_us_payroll_utils.get_parameter('S3',ppa.legislative_parameters),
144: to_date(pay_us_payroll_utils.get_parameter('EFFECTIVE_DATE',
145: ppa.legislative_parameters)
146: ,'dd-mon-yyyy')

Line 143: pay_us_payroll_utils.get_parameter('S3',ppa.legislative_parameters),

139: start_date,
140: business_group_id,
141: pay_us_payroll_utils.get_parameter('S1',ppa.legislative_parameters),
142: pay_us_payroll_utils.get_parameter('S2',ppa.legislative_parameters),
143: pay_us_payroll_utils.get_parameter('S3',ppa.legislative_parameters),
144: to_date(pay_us_payroll_utils.get_parameter('EFFECTIVE_DATE',
145: ppa.legislative_parameters)
146: ,'dd-mon-yyyy')
147: from pay_payroll_actions ppa

Line 144: to_date(pay_us_payroll_utils.get_parameter('EFFECTIVE_DATE',

140: business_group_id,
141: pay_us_payroll_utils.get_parameter('S1',ppa.legislative_parameters),
142: pay_us_payroll_utils.get_parameter('S2',ppa.legislative_parameters),
143: pay_us_payroll_utils.get_parameter('S3',ppa.legislative_parameters),
144: to_date(pay_us_payroll_utils.get_parameter('EFFECTIVE_DATE',
145: ppa.legislative_parameters)
146: ,'dd-mon-yyyy')
147: from pay_payroll_actions ppa
148: where ppa.payroll_action_id = cp_payroll_action_id;