APPS.PAY_US_W2C_RPT dependencies on PAY_US_PAYROLL_UTILS

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

83: )
84: IS
85: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
86: select
87: pay_us_payroll_utils.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),
88: pay_us_payroll_utils.get_parameter('PER_ID',ppa.legislative_parameters),
89: pay_us_payroll_utils.get_parameter('ASG_SET',ppa.legislative_parameters),
90: pay_us_payroll_utils.get_parameter('PRINT',ppa.legislative_parameters),
91: effective_date,

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

84: IS
85: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
86: select
87: pay_us_payroll_utils.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),
88: pay_us_payroll_utils.get_parameter('PER_ID',ppa.legislative_parameters),
89: pay_us_payroll_utils.get_parameter('ASG_SET',ppa.legislative_parameters),
90: pay_us_payroll_utils.get_parameter('PRINT',ppa.legislative_parameters),
91: effective_date,
92: start_date,

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

85: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
86: select
87: pay_us_payroll_utils.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),
88: pay_us_payroll_utils.get_parameter('PER_ID',ppa.legislative_parameters),
89: pay_us_payroll_utils.get_parameter('ASG_SET',ppa.legislative_parameters),
90: pay_us_payroll_utils.get_parameter('PRINT',ppa.legislative_parameters),
91: effective_date,
92: start_date,
93: business_group_id,

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

86: select
87: pay_us_payroll_utils.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),
88: pay_us_payroll_utils.get_parameter('PER_ID',ppa.legislative_parameters),
89: pay_us_payroll_utils.get_parameter('ASG_SET',ppa.legislative_parameters),
90: pay_us_payroll_utils.get_parameter('PRINT',ppa.legislative_parameters),
91: effective_date,
92: start_date,
93: business_group_id,
94: pay_us_payroll_utils.get_parameter('S1',ppa.legislative_parameters),

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

90: pay_us_payroll_utils.get_parameter('PRINT',ppa.legislative_parameters),
91: effective_date,
92: start_date,
93: business_group_id,
94: pay_us_payroll_utils.get_parameter('S1',ppa.legislative_parameters),
95: pay_us_payroll_utils.get_parameter('S2',ppa.legislative_parameters),
96: pay_us_payroll_utils.get_parameter('S3',ppa.legislative_parameters),
97: to_date(pay_us_payroll_utils.get_parameter('EFFECTIVE_DATE',
98: ppa.legislative_parameters)

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

91: effective_date,
92: start_date,
93: business_group_id,
94: pay_us_payroll_utils.get_parameter('S1',ppa.legislative_parameters),
95: pay_us_payroll_utils.get_parameter('S2',ppa.legislative_parameters),
96: pay_us_payroll_utils.get_parameter('S3',ppa.legislative_parameters),
97: to_date(pay_us_payroll_utils.get_parameter('EFFECTIVE_DATE',
98: ppa.legislative_parameters)
99: ,'dd-mon-yyyy')

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

92: start_date,
93: business_group_id,
94: pay_us_payroll_utils.get_parameter('S1',ppa.legislative_parameters),
95: pay_us_payroll_utils.get_parameter('S2',ppa.legislative_parameters),
96: pay_us_payroll_utils.get_parameter('S3',ppa.legislative_parameters),
97: to_date(pay_us_payroll_utils.get_parameter('EFFECTIVE_DATE',
98: ppa.legislative_parameters)
99: ,'dd-mon-yyyy')
100: from pay_payroll_actions ppa

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

93: business_group_id,
94: pay_us_payroll_utils.get_parameter('S1',ppa.legislative_parameters),
95: pay_us_payroll_utils.get_parameter('S2',ppa.legislative_parameters),
96: pay_us_payroll_utils.get_parameter('S3',ppa.legislative_parameters),
97: to_date(pay_us_payroll_utils.get_parameter('EFFECTIVE_DATE',
98: ppa.legislative_parameters)
99: ,'dd-mon-yyyy')
100: from pay_payroll_actions ppa
101: where ppa.payroll_action_id = cp_payroll_action_id;