DBA Data[Home] [Help]

APPS.PAY_CA_WORKFLOW_API_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 56: FROM pay_assignment_actions paa,

52:
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

Line 146: FROM pay_assignment_actions paa,

142:
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