DBA Data[Home] [Help]

APPS.PAY_US_WORKFLOW_API_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 107: pay_payroll_actions ppa,

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)
111: and ppa.business_group_id = ln_business_group_id

Line 526: pay_payroll_actions ppa,

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
530: and ppa.payroll_action_id = paa.payroll_action_id