APPS.PAY_EOSURVEY_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 615: procedure find_persons(p_pactid in pay_assignment_actions.payroll_action_id%type

611: hr_utility.set_location('Leaving.. ' || l_package,200);
612: end app_fire_count;
613:
614:
615: procedure find_persons(p_pactid in pay_assignment_actions.payroll_action_id%type
616: ,p_thread in number)
617:
618: is
619:

Line 623: CURSOR c_leg_param(l_pact_id pay_assignment_actions.payroll_action_id%type)

619:
620: /* This cursor picks up the legislative_paramters and the end date for the
621: the given pactid . */
622:
623: CURSOR c_leg_param(l_pact_id pay_assignment_actions.payroll_action_id%type)
624: IS
625: SELECT ppa.legislative_parameters,ppa.start_date,ppa.effective_date
626: FROM pay_payroll_actions ppa
627: WHERE ppa.payroll_action_id =l_pact_id;

Line 659: inserted in pay_assignment_Actions for a specific chunk and pactid.

655: AND entity_id =nvl(l_entity_id,entity_id)
656: AND hierarchy_version_id = l_version_id;
657:
658: /* This cursor picks up all the assignment actions that has been
659: inserted in pay_assignment_Actions for a specific chunk and pactid.
660: It also picks up the person_id stored in serial_number. */
661:
662: CURSOR c_fte_asgn(l_pactid pay_payroll_actions.payroll_action_id%type,
663: l_chunk pay_assignment_actions.chunk_number%type)

Line 663: l_chunk pay_assignment_actions.chunk_number%type)

659: inserted in pay_assignment_Actions for a specific chunk and pactid.
660: It also picks up the person_id stored in serial_number. */
661:
662: CURSOR c_fte_asgn(l_pactid pay_payroll_actions.payroll_action_id%type,
663: l_chunk pay_assignment_actions.chunk_number%type)
664: IS
665: SELECT assignment_action_id,
666: assignment_id,
667: serial_number,

Line 669: FROM pay_assignment_actions

665: SELECT assignment_action_id,
666: assignment_id,
667: serial_number,
668: source_action_id location_id
669: FROM pay_assignment_actions
670: WHERE payroll_action_id = l_pactid
671: AND chunk_number = l_chunk;
672:
673: /* This cursor picks up the max of asact_id which has been locked in pay_action_interlocks.

Line 676: CURSOR c_max_asact_id(l_locking_asact_id pay_assignment_actions.assignment_action_id%type)

672:
673: /* This cursor picks up the max of asact_id which has been locked in pay_action_interlocks.
674: this was selected during action creation. */
675:
676: CURSOR c_max_asact_id(l_locking_asact_id pay_assignment_actions.assignment_action_id%type)
677: IS
678: SELECT locked_action_id
679: FROM pay_action_interlocks
680: WHERE locking_action_id = l_locking_asact_id;

Line 771: l_max_asact_id pay_assignment_Actions.assignment_action_id%type;

767: l_leg_param pay_payroll_actions.legislative_parameters%type;
768: l_period_end date;
769: l_period_start date;
770: l_est_count number;
771: l_max_asact_id pay_assignment_Actions.assignment_action_id%type;
772: l_location_id per_assignments_f.location_id%TYPE;
773: l_person_id per_people_f.person_id%type;
774: l_job varchar2(10);
775: l_assignment_type varchar2(10);

Line 1201: FROM pay_assignment_actions paa,

1197: c_period_end date)
1198: IS
1199: SELECT to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1200: paa.assignment_action_id),16))
1201: FROM pay_assignment_actions paa,
1202: pay_payroll_actions ppa
1203: WHERE paa.assignment_id = c_assignment_id
1204: AND ppa.payroll_action_id = paa.payroll_action_id
1205: AND ppa.effective_date <= c_period_end

Line 1269: l_asact_id pay_assignment_actions.assignment_action_id%type;

1265: and ppt.person_type_id = ppf.person_type_id
1266: and pps.person_id = ppf.person_id;
1267:
1268: l_hours_worked per_assignments_f.normal_hours%type;
1269: l_asact_id pay_assignment_actions.assignment_action_id%type;
1270: l_year varchar2(4);
1271: calendar_period_start date;
1272: calendar_period_end date;
1273: calendar_next_period_start date;