APPS.PAY_ASG_PROCESS_GRP_PKG dependencies on PAY_GROUP_DEFINITIONS

Line 59: from pay_group_definitions

55: begin
56: --
57: select group_definition_id
58: into l_definition_id
59: from pay_group_definitions
60: where name = p_definition_name;
61: --
62: return l_definition_id;
63: --

Line 71: lock table pay_group_definitions in share mode;

67: --
68: -- Need to lock the table to esnure only
69: -- one thread creates the group row.
70: --
71: lock table pay_group_definitions in share mode;
72: --
73: -- Ensure that nothing has created
74: -- the row in the meantime
75: select group_definition_id

Line 77: from pay_group_definitions

73: -- Ensure that nothing has created
74: -- the row in the meantime
75: select group_definition_id
76: into l_definition_id
77: from pay_group_definitions
78: where name = p_definition_name;
79: --
80: return l_definition_id;
81: --

Line 85: select pay_group_definitions_s.nextval

81: --
82: exception
83: when no_data_found then
84: --
85: select pay_group_definitions_s.nextval
86: into l_definition_id
87: from dual;
88: --
89: insert into pay_group_definitions

Line 89: insert into pay_group_definitions

85: select pay_group_definitions_s.nextval
86: into l_definition_id
87: from dual;
88: --
89: insert into pay_group_definitions
90: (group_definition_id,
91: name)
92: values
93: (l_definition_id,

Line 210: l_definition_id pay_group_definitions.group_definition_id%type;

206: p_update_row in varchar2 default 'Y'
207: )
208: return number
209: is
210: l_definition_id pay_group_definitions.group_definition_id%type;
211: l_object_group_id pay_object_groups.object_group_id%type;
212: l_start_date pay_object_groups.start_date%type;
213: l_end_date pay_object_groups.end_date%type;
214: l_update boolean;

Line 388: l_group_name pay_group_definitions.name%type;

384: p_effective_end_date in date,
385: p_payroll_id in number
386: )
387: is
388: l_group_name pay_group_definitions.name%type;
389: l_person_group_id pay_object_groups.object_group_id%type;
390: l_asg_group_id pay_object_groups.object_group_id%type;
391: begin
392: --

Line 624: from pay_group_definitions pgd,

620: begin
621: --
622: select pgd.name
623: into p_definition_name
624: from pay_group_definitions pgd,
625: pay_object_groups pog_ppf,
626: pay_object_groups pog_paf
627: where pog_paf.source_id = p_assignment_id
628: and pog_paf.source_type = 'PAF'

Line 657: l_old_group_name pay_group_definitions.name%type;

653: p_old_payroll_id in number,
654: p_new_payroll_id in number
655: )
656: is
657: l_old_group_name pay_group_definitions.name%type;
658: l_new_group_name pay_group_definitions.name%type;
659: begin
660: --
661: if ( p_old_payroll_id is null

Line 658: l_new_group_name pay_group_definitions.name%type;

654: p_new_payroll_id in number
655: )
656: is
657: l_old_group_name pay_group_definitions.name%type;
658: l_new_group_name pay_group_definitions.name%type;
659: begin
660: --
661: if ( p_old_payroll_id is null
662: and p_new_payroll_id is null) then