APPS.PAY_CA_YEPP_MISS_ASSIGN_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 339: FROM per_all_assignments_f asg,

335: cp_bus_grp number,
336: cp_report_type varchar2,
337: cp_tax_unit_id number) is
338: SELECT DISTINCT asg.assignment_id ass_id
339: FROM per_all_assignments_f asg,
340: pay_assignment_actions paa,
341: pay_payroll_actions ppa,
342: per_all_people_f ppf
343: WHERE ppa.effective_date BETWEEN cp_effective_date

Line 375: FROM per_all_assignments_f ASG,

371: cp_bus_grp number,
372: cp_report_type varchar2,
373: cp_pre_id number) is
374: SELECT DISTINCT ASG.assignment_id ass_id
375: FROM per_all_assignments_f ASG,
376: pay_all_payrolls_f PPY,
377: hr_soft_coding_keyflex SCL
378: WHERE ASG.business_group_id + 0 = cp_bus_grp
379: AND ASG.assignment_type = 'E'

Line 423: FROM per_all_assignments_f ASG,

419: cp_bus_grp number,
420: cp_report_type varchar2,
421: cp_pre_id number) is
422: SELECT DISTINCT ASG.assignment_id ass_id
423: FROM per_all_assignments_f ASG,
424: pay_all_payrolls_f PPY,
425: hr_soft_coding_keyflex SCL
426: WHERE ASG.business_group_id + 0 = cp_bus_grp
427: AND ASG.assignment_type = 'E'

Line 503: FROM per_all_assignments_f

499: AND language = userenv('LANG');
500:
501: CURSOR c_person_id(c_assign_id number) IS
502: SELECT person_id
503: FROM per_all_assignments_f
504: WHERE assignment_id = c_assign_id
505: AND business_group_id+0 = p_bus_grp;
506:
507: CURSOR c_assignment_no(c_assign_id number) IS

Line 509: FROM per_all_assignments_f

505: AND business_group_id+0 = p_bus_grp;
506:
507: CURSOR c_assignment_no(c_assign_id number) IS
508: SELECT assignment_number
509: FROM per_all_assignments_f
510: WHERE assignment_id = c_assign_id;
511:
512: CURSOR c_employee_details(c_person_id number) IS
513: SELECT full_name,national_identifier

Line 545: lv_assn_id per_all_assignments_f.assignment_id%type;

541:
542:
543: /* Local variables */
544:
545: lv_assn_id per_all_assignments_f.assignment_id%type;
546: lv_result_value number;
547: lv_person_id per_all_people_f.person_id%type;
548: lv_gre_name hr_all_organization_units_tl.name%type;
549: lv_pre_name hr_all_organization_units_tl.name%type;