APPS.PAY_SE_STAT_OFFICE_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 491: FROM pay_assignment_actions paa,

487: fnd_date.canonical_to_date(prrv1.result_value) start_date,
488: prrv2.result_value full_day,
489: fnd_date.canonical_to_date(prrv3.result_value) end_date,
490: prrv4.result_value part_day
491: FROM pay_assignment_actions paa,
492: pay_payroll_actions ppa,
493: pay_run_results prr,
494: pay_run_result_values prrv1,
495: pay_run_result_values prrv2,

Line 524: FROM pay_assignment_actions paa,

520: p_report_end_date DATE,
521: p_full_day_iv NUMBER,
522: p_source_id NUMBER) IS
523: SELECT max(to_number(prrv1.result_value)) full_day
524: FROM pay_assignment_actions paa,
525: pay_payroll_actions ppa,
526: pay_run_results prr,
527: pay_run_result_values prrv1
528: WHERE ppa.effective_date BETWEEN p_report_start_date

Line 552: FROM pay_assignment_actions paa,

548: SELECT fnd_date.canonical_to_date(prrv1.result_value) start_date,
549: fnd_date.canonical_to_date(prrv2.result_value) fourteenth_date,
550: fnd_date.canonical_to_date(prrv3.result_value) end_date,
551: prrv4.result_value employer_days
552: FROM pay_assignment_actions paa,
553: pay_payroll_actions ppa,
554: pay_run_results prr,
555: pay_run_result_values prrv1,
556: pay_run_result_values prrv2,

Line 704: SELECT pay_assignment_actions_s.nextval INTO l_assact_id FROM dual;

700: IF l_assignment_id <> l_assignments_rec.assignment_id THEN
701: l_assignment_id := l_assignments_rec.assignment_id;
702:
703:
704: SELECT pay_assignment_actions_s.nextval INTO l_assact_id FROM dual;
705: hr_nonrun_asact.insact
706: (l_assact_id
707: ,l_assignments_rec.assignment_id
708: ,p_payroll_action_id

Line 1138: pay_assignment_actions assg,

1134: pai.action_information11 part_day,
1135: pai.action_information12 correction
1136: FROM
1137: pay_payroll_actions paa,
1138: pay_assignment_actions assg,
1139: pay_action_information pai
1140: WHERE
1141: paa.payroll_action_id = p_payroll_action_id
1142: AND assg.payroll_action_id = paa.payroll_action_id