APPS.PAY_PYUCSLIS_PKG dependencies on DUAL

Line 526: FROM DUAL

522: p_request_id,
523: p_program_application_id,
524: p_program_id,
525: l_update_date
526: FROM DUAL
527: /* Duplicate check. Required because of organization list Includes */
528: WHERE NOT EXISTS
529: (SELECT NULL
530: FROM per_organization_list pol

Line 730: FROM sys.dual

726: p_request_id,
727: p_program_application_id,
728: p_program_id,
729: l_update_date
730: FROM sys.dual
731: WHERE EXISTS
732: (SELECT NULL
733: FROM hr_all_positions_f pp,
734: per_organization_list ol

Line 6161: ** Cursor to select the individual person ID's for each person in the range

6157:
6158: l_proc varchar2(100) := g_package||'action_creation';
6159:
6160: /*
6161: ** Cursor to select the individual person ID's for each person in the range
6162: ** between stperson and endperson.
6163: **
6164: ** Use the emp/apl/cwk number columns to filter out contact only people
6165: ** unless they become a Emp/Apl/Cwl in the future.

Line 6310: from dual;

6306: for perrec in c_actions(pactid, stperson, endperson) loop
6307:
6308: select pay_assignment_actions_s.nextval
6309: into l_lockingactid
6310: from dual;
6311:
6312: if l_temp_person_id is null then
6313: /*
6314: ** This is the first iteration so set the temp variable

Line 6351: from dual;

6347: for asgrec in c_actions_prev(pactid, stperson, endperson) loop
6348:
6349: select pay_assignment_actions_s.nextval
6350: into l_lockingactid
6351: from dual;
6352:
6353: if l_temp_person_id is null then
6354: /*
6355: ** This is the first iteration so set the temp variable

Line 6424: -- processing required for each individual person. We have access

6420: -- |----------------------------< archive_data >------------------------------|
6421: -- ----------------------------------------------------------------------------
6422: --
6423: -- Purpose : This process is called for each assignment action and performs the
6424: -- processing required for each individual person. We have access
6425: -- to an assignment ID but need to determine security for a person
6426: -- so convert the assignment ID into a person ID and then kickoff
6427: -- the processing for that person.
6428: --

Line 6591: x_restrict_on_individual_asg => rtrim(r_sec.restrict_on_individual_asg),

6587: x_custom_restriction_flag => rtrim(r_sec.custom_restriction_flag),
6588: x_restriction_text => rtrim(r_sec.restriction_text),
6589: x_exclude_business_groups_flag => rtrim(r_sec.exclude_business_groups_flag),
6590: x_org_security_mode => rtrim(r_sec.org_security_mode),
6591: x_restrict_on_individual_asg => rtrim(r_sec.restrict_on_individual_asg),
6592: x_top_organization_method => rtrim(r_sec.top_organization_method),
6593: x_top_position_method => rtrim(r_sec.top_position_method)
6594: );
6595: --

Line 6632: x_restrict_on_individual_asg => r_sec.restrict_on_individual_asg,

6628: x_custom_restriction_flag => r_sec.custom_restriction_flag,
6629: x_restriction_text => r_sec.restriction_text,
6630: x_exclude_business_groups_flag => r_sec.exclude_business_groups_flag,
6631: x_org_security_mode => r_sec.org_security_mode,
6632: x_restrict_on_individual_asg => r_sec.restrict_on_individual_asg,
6633: x_top_organization_method => r_sec.top_organization_method,
6634: x_top_position_method => r_sec.top_position_method,
6635: x_request_id => l_req_id,
6636: x_program_application_id => l_appl_id,