[Home] [Help]
1122: --
1123: /* Look for all the assignments on the same group */
1124: cursor dp (p_asg_id in number) is
1125: select distinct pog_grp.source_id
1126: from pay_object_groups pog_act,
1127: pay_object_groups pog_grp
1128: where pog_act.source_id = p_asg_id
1129: and pog_act.source_type = 'PAF'
1130: and pog_act.parent_object_group_id = pog_grp.parent_object_group_id -- the personlevel group
1123: /* Look for all the assignments on the same group */
1124: cursor dp (p_asg_id in number) is
1125: select distinct pog_grp.source_id
1126: from pay_object_groups pog_act,
1127: pay_object_groups pog_grp
1128: where pog_act.source_id = p_asg_id
1129: and pog_act.source_type = 'PAF'
1130: and pog_act.parent_object_group_id = pog_grp.parent_object_group_id -- the personlevel group
1131: and pog_grp.source_type = 'PAF';
3457: ''Y'') = ''N''';
3458: --
3459: intretgrpdep := '
3460: and not exists (select ''''
3461: from pay_object_groups pay_pog_asg2
3462: where pay_pog_asg2.parent_object_group_id = pay_pos.object_group_id
3463: and pay_pog_asg2.source_type = ''PAF''
3464: and hr_dynsql.process_group_seq_locked(pay_pog_asg2.source_id,
3465: pay_pac.effective_date,
3552: --
3553: retdefasgpg := '
3554: from
3555: pay_payroll_actions pay_pac,
3556: pay_object_groups pay_pos
3557: where pay_pac.payroll_action_id = :payroll_action_id
3558: and pay_pos.source_type = ''PPF''
3559: and exists (select ''''
3560: from pay_retro_assignments pay_ret_asg,
3558: and pay_pos.source_type = ''PPF''
3559: and exists (select ''''
3560: from pay_retro_assignments pay_ret_asg,
3561: per_all_assignments_f pay_asg2,
3562: pay_object_groups pay_pog_asg2
3563: where pay_pog_asg2.parent_object_group_id = pay_pos.object_group_id
3564: and pay_pog_asg2.source_type = ''PAF''
3565: and pay_asg2.assignment_id = pay_pog_asg2.source_id
3566: and pay_asg2.payroll_id + 0 = pay_pac.payroll_id