APPS.HR_DYNSQL dependencies on PAY_OBJECT_GROUPS

Line 1131: from pay_object_groups pog_act,

1127: --
1128: /* Look for all the assignments on the same group */
1129: cursor dp (p_asg_id in number) is
1130: select distinct pog_grp.source_id
1131: from pay_object_groups pog_act,
1132: pay_object_groups pog_grp
1133: where pog_act.source_id = p_asg_id
1134: and pog_act.source_type = 'PAF'
1135: and pog_act.parent_object_group_id = pog_grp.parent_object_group_id -- the personlevel group

Line 1132: pay_object_groups pog_grp

1128: /* Look for all the assignments on the same group */
1129: cursor dp (p_asg_id in number) is
1130: select distinct pog_grp.source_id
1131: from pay_object_groups pog_act,
1132: pay_object_groups pog_grp
1133: where pog_act.source_id = p_asg_id
1134: and pog_act.source_type = 'PAF'
1135: and pog_act.parent_object_group_id = pog_grp.parent_object_group_id -- the personlevel group
1136: and pog_grp.source_type = 'PAF';

Line 3539: from pay_object_groups pay_pog_asg2

3535: ''Y'') = ''N''';
3536: --
3537: intretgrpdep := '
3538: and not exists (select ''''
3539: from pay_object_groups pay_pog_asg2
3540: where pay_pog_asg2.parent_object_group_id = pay_pos.object_group_id
3541: and pay_pog_asg2.source_type = ''PAF''
3542: and hr_dynsql.process_group_seq_locked(pay_pog_asg2.source_id,
3543: pay_pac.effective_date,

Line 3652: pay_object_groups pay_pos

3648: --
3649: retdefasgpg := '
3650: from
3651: pay_payroll_actions pay_pac,
3652: pay_object_groups pay_pos
3653: where pay_pac.payroll_action_id = :payroll_action_id
3654: and pay_pos.source_type = ''PPF''
3655: and exists (select ''''
3656: from pay_retro_assignments pay_ret_asg,

Line 3658: pay_object_groups pay_pog_asg2

3654: and pay_pos.source_type = ''PPF''
3655: and exists (select ''''
3656: from pay_retro_assignments pay_ret_asg,
3657: per_all_assignments_f pay_asg2,
3658: pay_object_groups pay_pog_asg2
3659: where pay_pog_asg2.parent_object_group_id = pay_pos.object_group_id
3660: and pay_pog_asg2.source_type = ''PAF''
3661: and pay_asg2.assignment_id = pay_pog_asg2.source_id
3662: and pay_asg2.payroll_id + 0 = pay_pac.payroll_id

Line 3674: pay_object_groups pay_pos

3670: -- Bug 1308309, Quick-Retropay
3671: qretdefasgpg := '
3672: from
3673: pay_payroll_actions pay_pac,
3674: pay_object_groups pay_pos
3675: where pay_pac.payroll_action_id = :payroll_action_id
3676: and pay_pos.source_type = ''PPF''
3677: and exists (select ''''
3678: from pay_retro_assignments pay_ret_asg,

Line 3680: pay_object_groups pay_pog_asg2

3676: and pay_pos.source_type = ''PPF''
3677: and exists (select ''''
3678: from pay_retro_assignments pay_ret_asg,
3679: per_all_assignments_f pay_asg2,
3680: pay_object_groups pay_pog_asg2
3681: where pay_pog_asg2.parent_object_group_id = pay_pos.object_group_id
3682: and pay_pog_asg2.source_type = ''PAF''
3683: and pay_asg2.assignment_id = pay_pog_asg2.source_id
3684: and pay_asg2.payroll_id + 0 = pay_pac.payroll_id