DBA Data[Home] [Help]

APPS.PAY_SG_PAYSLIP_ARCHIVE dependencies on PAY_SG_ASG_ELEMENTS_V

Line 117: -- It uses SG Pay Advice view 'pay_sg_asg_elements_v'

113:
114:
115: --------------------------------------------------------------------+
116: -- This procedure archives the elements and run result values.
117: -- It uses SG Pay Advice view 'pay_sg_asg_elements_v'
118: -- to get the elements and corresponding payments.
119: --------------------------------------------------------------------+
120:
121: PROCEDURE archive_stat_elements(p_assignment_action_id IN NUMBER,

Line 138: FROM pay_sg_asg_elements_v

134: , amount
135: , foreign_currency_code
136: , hours
137: , exchange_rate
138: FROM pay_sg_asg_elements_v
139: WHERE run_assignment_action_id = p_assignment_action_id
140: AND classification_group IS NOT NULL;
141:
142: