DBA Data[Home] [Help]

APPS.PAY_CA_WORKFLOW_API_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 57: pay_payroll_actions ppa

53: CURSOR asg_roe_info_cur (p_req_id number) IS
54: SELECT to_char(count(paa.assignment_action_id)) ASG_COUNT,
55: paa.action_status ASG_STATUS
56: FROM pay_assignment_actions paa,
57: pay_payroll_actions ppa
58: WHERE paa.payroll_action_id = ppa.payroll_action_id
59: AND ppa.request_id = to_number(p_req_id)
60: AND ppa.business_group_id = ln_business_group_id
61: AND ppa.effective_date =

Line 147: pay_payroll_actions ppa

143: CURSOR asg_roe_mag_info_cur (p_req_id number) IS
144: SELECT to_char(count(paa.assignment_action_id)) ASG_COUNT,
145: paa.action_status ASG_STATUS
146: FROM pay_assignment_actions paa,
147: pay_payroll_actions ppa
148: WHERE paa.payroll_action_id = ppa.payroll_action_id
149: AND ppa.request_id = to_number(p_req_id)
150: AND ppa.business_group_id = ln_business_group_id
151: AND ppa.effective_date =