DBA Data[Home] [Help]

APPS.PAY_US_WORKFLOW_API_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 106: from pay_assignment_actions paa,

102: IS
103: select ppf.payroll_name PAYROLL_NAME,
104: to_char(count(paa.assignment_action_id)) ASG_COUNT,
105: paa.action_status ASG_STATUS
106: from pay_assignment_actions paa,
107: pay_payroll_actions ppa,
108: pay_all_payrolls_f ppf
109: where paa.payroll_action_id = ppa.payroll_action_id
110: and ppa.request_id = to_number(p_req_id)

Line 525: pay_assignment_actions paa,

521: hr_utility.trace(' Business Id = '|| to_char(X_bg_id));
522:
523: begin
524: select distinct('Y') into l_is_retro from
525: pay_assignment_actions paa,
526: pay_payroll_actions ppa,
527: pay_retro_assignments pra
528: where ppa.payroll_id = X_payroll_id
529: --ppa.business_group_id = X_bg_id