DBA Data[Home] [Help]

APPS.PAY_BEE_UPGRADE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 719: pay_payroll_actions pct,

715: pbg.business_group_id,
716: pbg.legislation_code,
717: cact.payroll_action_id
718: from pay_temp_object_actions cact,
719: pay_payroll_actions pct,
720: per_business_groups pbg
721: where cact.object_id = P_ASG_ID
722: and pct.payroll_action_id = cact.payroll_action_id
723: and pbg.business_group_id = pct.business_group_id;

Line 730: L_PCT_ID pay_payroll_actions.payroll_action_id%TYPE := NULL;

726: --
727: L_ASG_ID per_all_assignments_f.assignment_id%TYPE := P_ASG_ID;
728: L_BG_ID per_all_assignments_f.business_group_id%TYPE NULL;
729: L_LEG_CODE per_business_groups.legislation_code%TYPE := NULL;
730: L_PCT_ID pay_payroll_actions.payroll_action_id%TYPE := NULL;
731: --
732: cursor csr_max_chunck_num (p_pct_id number) is
733: select max(cact.chunk_number) last_chunk
734: from pay_temp_object_actions cact