APPS.PAY_ZA_EMP201 dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 471: v_incl_sw hr_assignment_set_amendments.include_or_exclude%type;

467: l_calendar_month varchar(30);
468: l_month_start date ;
469: l_month_end date ;
470: l_asg_set_id number;
471: v_incl_sw hr_assignment_set_amendments.include_or_exclude%type;
472: asg_include boolean;
473: prev_asg_id number := 0 ;
474: lockingactid number;
475: l_legal_entity_id number;

Line 539: from hr_assignment_set_amendments

535: -- find out if assignments in assignment-set are set to Include or Exclude.
536: begin
537: select distinct include_or_exclude
538: into v_incl_sw
539: from hr_assignment_set_amendments
540: where assignment_set_id = l_asg_set_id;
541: exception
542: when no_data_found then
543: -- default to Include, should not go here though.

Line 564: from hr_assignment_set_amendments

560: inc_flag varchar2(5);
561: begin
562: select include_or_exclude
563: into inc_flag
564: from hr_assignment_set_amendments
565: where assignment_set_id = l_asg_set_id
566: and assignment_id = asgrec.assignment_id;
567:
568: if inc_flag = 'E' then