APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_PHONES

Line 394: ,p_phn_h_phone_id OUT NOCOPY per_phones.phone_id%TYPE

390: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
391: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
392: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
393: ,p_addr_object_version_number OUT NOCOPY per_addresses.object_version_number%TYPE
394: ,p_phn_h_phone_id OUT NOCOPY per_phones.phone_id%TYPE
395: ,p_phn_h_date_from IN per_phones.date_from%TYPE
396: ,p_phn_h_date_to IN per_phones.date_to%TYPE
397: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
398: ,p_phn_h_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE

Line 395: ,p_phn_h_date_from IN per_phones.date_from%TYPE

391: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
392: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
393: ,p_addr_object_version_number OUT NOCOPY per_addresses.object_version_number%TYPE
394: ,p_phn_h_phone_id OUT NOCOPY per_phones.phone_id%TYPE
395: ,p_phn_h_date_from IN per_phones.date_from%TYPE
396: ,p_phn_h_date_to IN per_phones.date_to%TYPE
397: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
398: ,p_phn_h_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
399: ,p_phn_w_phone_id OUT NOCOPY per_phones.phone_id%TYPE

Line 396: ,p_phn_h_date_to IN per_phones.date_to%TYPE

392: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
393: ,p_addr_object_version_number OUT NOCOPY per_addresses.object_version_number%TYPE
394: ,p_phn_h_phone_id OUT NOCOPY per_phones.phone_id%TYPE
395: ,p_phn_h_date_from IN per_phones.date_from%TYPE
396: ,p_phn_h_date_to IN per_phones.date_to%TYPE
397: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
398: ,p_phn_h_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
399: ,p_phn_w_phone_id OUT NOCOPY per_phones.phone_id%TYPE
400: ,p_phn_w_date_from IN per_phones.date_from%TYPE

Line 397: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE

393: ,p_addr_object_version_number OUT NOCOPY per_addresses.object_version_number%TYPE
394: ,p_phn_h_phone_id OUT NOCOPY per_phones.phone_id%TYPE
395: ,p_phn_h_date_from IN per_phones.date_from%TYPE
396: ,p_phn_h_date_to IN per_phones.date_to%TYPE
397: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
398: ,p_phn_h_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
399: ,p_phn_w_phone_id OUT NOCOPY per_phones.phone_id%TYPE
400: ,p_phn_w_date_from IN per_phones.date_from%TYPE
401: ,p_phn_w_date_to IN per_phones.date_to%TYPE

Line 398: ,p_phn_h_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE

394: ,p_phn_h_phone_id OUT NOCOPY per_phones.phone_id%TYPE
395: ,p_phn_h_date_from IN per_phones.date_from%TYPE
396: ,p_phn_h_date_to IN per_phones.date_to%TYPE
397: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
398: ,p_phn_h_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
399: ,p_phn_w_phone_id OUT NOCOPY per_phones.phone_id%TYPE
400: ,p_phn_w_date_from IN per_phones.date_from%TYPE
401: ,p_phn_w_date_to IN per_phones.date_to%TYPE
402: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE

Line 399: ,p_phn_w_phone_id OUT NOCOPY per_phones.phone_id%TYPE

395: ,p_phn_h_date_from IN per_phones.date_from%TYPE
396: ,p_phn_h_date_to IN per_phones.date_to%TYPE
397: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
398: ,p_phn_h_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
399: ,p_phn_w_phone_id OUT NOCOPY per_phones.phone_id%TYPE
400: ,p_phn_w_date_from IN per_phones.date_from%TYPE
401: ,p_phn_w_date_to IN per_phones.date_to%TYPE
402: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
403: ,p_phn_w_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE

Line 400: ,p_phn_w_date_from IN per_phones.date_from%TYPE

396: ,p_phn_h_date_to IN per_phones.date_to%TYPE
397: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
398: ,p_phn_h_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
399: ,p_phn_w_phone_id OUT NOCOPY per_phones.phone_id%TYPE
400: ,p_phn_w_date_from IN per_phones.date_from%TYPE
401: ,p_phn_w_date_to IN per_phones.date_to%TYPE
402: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
403: ,p_phn_w_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
404: ,p_phn_m_phone_id OUT NOCOPY per_phones.phone_id%TYPE

Line 401: ,p_phn_w_date_to IN per_phones.date_to%TYPE

397: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
398: ,p_phn_h_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
399: ,p_phn_w_phone_id OUT NOCOPY per_phones.phone_id%TYPE
400: ,p_phn_w_date_from IN per_phones.date_from%TYPE
401: ,p_phn_w_date_to IN per_phones.date_to%TYPE
402: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
403: ,p_phn_w_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
404: ,p_phn_m_phone_id OUT NOCOPY per_phones.phone_id%TYPE
405: ,p_phn_m_date_from IN per_phones.date_from%TYPE

Line 402: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE

398: ,p_phn_h_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
399: ,p_phn_w_phone_id OUT NOCOPY per_phones.phone_id%TYPE
400: ,p_phn_w_date_from IN per_phones.date_from%TYPE
401: ,p_phn_w_date_to IN per_phones.date_to%TYPE
402: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
403: ,p_phn_w_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
404: ,p_phn_m_phone_id OUT NOCOPY per_phones.phone_id%TYPE
405: ,p_phn_m_date_from IN per_phones.date_from%TYPE
406: ,p_phn_m_date_to IN per_phones.date_to%TYPE

Line 403: ,p_phn_w_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE

399: ,p_phn_w_phone_id OUT NOCOPY per_phones.phone_id%TYPE
400: ,p_phn_w_date_from IN per_phones.date_from%TYPE
401: ,p_phn_w_date_to IN per_phones.date_to%TYPE
402: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
403: ,p_phn_w_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
404: ,p_phn_m_phone_id OUT NOCOPY per_phones.phone_id%TYPE
405: ,p_phn_m_date_from IN per_phones.date_from%TYPE
406: ,p_phn_m_date_to IN per_phones.date_to%TYPE
407: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE

Line 404: ,p_phn_m_phone_id OUT NOCOPY per_phones.phone_id%TYPE

400: ,p_phn_w_date_from IN per_phones.date_from%TYPE
401: ,p_phn_w_date_to IN per_phones.date_to%TYPE
402: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
403: ,p_phn_w_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
404: ,p_phn_m_phone_id OUT NOCOPY per_phones.phone_id%TYPE
405: ,p_phn_m_date_from IN per_phones.date_from%TYPE
406: ,p_phn_m_date_to IN per_phones.date_to%TYPE
407: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
408: ,p_phn_m_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE

Line 405: ,p_phn_m_date_from IN per_phones.date_from%TYPE

401: ,p_phn_w_date_to IN per_phones.date_to%TYPE
402: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
403: ,p_phn_w_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
404: ,p_phn_m_phone_id OUT NOCOPY per_phones.phone_id%TYPE
405: ,p_phn_m_date_from IN per_phones.date_from%TYPE
406: ,p_phn_m_date_to IN per_phones.date_to%TYPE
407: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
408: ,p_phn_m_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
409: ,p_phn_hf_phone_id OUT NOCOPY per_phones.phone_id%TYPE

Line 406: ,p_phn_m_date_to IN per_phones.date_to%TYPE

402: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
403: ,p_phn_w_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
404: ,p_phn_m_phone_id OUT NOCOPY per_phones.phone_id%TYPE
405: ,p_phn_m_date_from IN per_phones.date_from%TYPE
406: ,p_phn_m_date_to IN per_phones.date_to%TYPE
407: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
408: ,p_phn_m_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
409: ,p_phn_hf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
410: ,p_phn_hf_date_from IN per_phones.date_from%TYPE

Line 407: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE

403: ,p_phn_w_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
404: ,p_phn_m_phone_id OUT NOCOPY per_phones.phone_id%TYPE
405: ,p_phn_m_date_from IN per_phones.date_from%TYPE
406: ,p_phn_m_date_to IN per_phones.date_to%TYPE
407: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
408: ,p_phn_m_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
409: ,p_phn_hf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
410: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
411: ,p_phn_hf_date_to IN per_phones.date_to%TYPE

Line 408: ,p_phn_m_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE

404: ,p_phn_m_phone_id OUT NOCOPY per_phones.phone_id%TYPE
405: ,p_phn_m_date_from IN per_phones.date_from%TYPE
406: ,p_phn_m_date_to IN per_phones.date_to%TYPE
407: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
408: ,p_phn_m_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
409: ,p_phn_hf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
410: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
411: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
412: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE

Line 409: ,p_phn_hf_phone_id OUT NOCOPY per_phones.phone_id%TYPE

405: ,p_phn_m_date_from IN per_phones.date_from%TYPE
406: ,p_phn_m_date_to IN per_phones.date_to%TYPE
407: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
408: ,p_phn_m_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
409: ,p_phn_hf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
410: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
411: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
412: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
413: ,p_phn_hf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE

Line 410: ,p_phn_hf_date_from IN per_phones.date_from%TYPE

406: ,p_phn_m_date_to IN per_phones.date_to%TYPE
407: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
408: ,p_phn_m_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
409: ,p_phn_hf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
410: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
411: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
412: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
413: ,p_phn_hf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
414: ,p_phn_wf_phone_id OUT NOCOPY per_phones.phone_id%TYPE

Line 411: ,p_phn_hf_date_to IN per_phones.date_to%TYPE

407: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
408: ,p_phn_m_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
409: ,p_phn_hf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
410: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
411: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
412: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
413: ,p_phn_hf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
414: ,p_phn_wf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
415: ,p_phn_wf_date_from IN per_phones.date_from%TYPE

Line 412: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE

408: ,p_phn_m_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
409: ,p_phn_hf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
410: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
411: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
412: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
413: ,p_phn_hf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
414: ,p_phn_wf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
415: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
416: ,p_phn_wf_date_to IN per_phones.date_to%TYPE

Line 413: ,p_phn_hf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE

409: ,p_phn_hf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
410: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
411: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
412: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
413: ,p_phn_hf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
414: ,p_phn_wf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
415: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
416: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
417: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE

Line 414: ,p_phn_wf_phone_id OUT NOCOPY per_phones.phone_id%TYPE

410: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
411: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
412: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
413: ,p_phn_hf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
414: ,p_phn_wf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
415: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
416: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
417: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
418: ,p_phn_wf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE

Line 415: ,p_phn_wf_date_from IN per_phones.date_from%TYPE

411: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
412: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
413: ,p_phn_hf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
414: ,p_phn_wf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
415: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
416: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
417: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
418: ,p_phn_wf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
419: ,p_pay_proposal_id OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE

Line 416: ,p_phn_wf_date_to IN per_phones.date_to%TYPE

412: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
413: ,p_phn_hf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
414: ,p_phn_wf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
415: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
416: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
417: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
418: ,p_phn_wf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
419: ,p_pay_proposal_id OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
420: ,p_change_date IN per_pay_proposals.change_date%TYPE

Line 417: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE

413: ,p_phn_hf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
414: ,p_phn_wf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
415: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
416: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
417: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
418: ,p_phn_wf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
419: ,p_pay_proposal_id OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
420: ,p_change_date IN per_pay_proposals.change_date%TYPE
421: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE

Line 418: ,p_phn_wf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE

414: ,p_phn_wf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
415: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
416: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
417: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
418: ,p_phn_wf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
419: ,p_pay_proposal_id OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
420: ,p_change_date IN per_pay_proposals.change_date%TYPE
421: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE
422: ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE

Line 1113: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE

1109: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
1110: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
1111: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
1112: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE
1113: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1114: ,p_phn_h_date_from IN per_phones.date_from%TYPE
1115: ,p_phn_h_date_to IN per_phones.date_to%TYPE
1116: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
1117: ,p_phn_h_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE

Line 1114: ,p_phn_h_date_from IN per_phones.date_from%TYPE

1110: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
1111: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
1112: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE
1113: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1114: ,p_phn_h_date_from IN per_phones.date_from%TYPE
1115: ,p_phn_h_date_to IN per_phones.date_to%TYPE
1116: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
1117: ,p_phn_h_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1118: ,p_phn_w_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE

Line 1115: ,p_phn_h_date_to IN per_phones.date_to%TYPE

1111: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
1112: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE
1113: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1114: ,p_phn_h_date_from IN per_phones.date_from%TYPE
1115: ,p_phn_h_date_to IN per_phones.date_to%TYPE
1116: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
1117: ,p_phn_h_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1118: ,p_phn_w_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1119: ,p_phn_w_date_from IN per_phones.date_from%TYPE

Line 1116: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE

1112: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE
1113: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1114: ,p_phn_h_date_from IN per_phones.date_from%TYPE
1115: ,p_phn_h_date_to IN per_phones.date_to%TYPE
1116: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
1117: ,p_phn_h_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1118: ,p_phn_w_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1119: ,p_phn_w_date_from IN per_phones.date_from%TYPE
1120: ,p_phn_w_date_to IN per_phones.date_to%TYPE

Line 1117: ,p_phn_h_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE

1113: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1114: ,p_phn_h_date_from IN per_phones.date_from%TYPE
1115: ,p_phn_h_date_to IN per_phones.date_to%TYPE
1116: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
1117: ,p_phn_h_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1118: ,p_phn_w_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1119: ,p_phn_w_date_from IN per_phones.date_from%TYPE
1120: ,p_phn_w_date_to IN per_phones.date_to%TYPE
1121: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE

Line 1118: ,p_phn_w_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE

1114: ,p_phn_h_date_from IN per_phones.date_from%TYPE
1115: ,p_phn_h_date_to IN per_phones.date_to%TYPE
1116: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
1117: ,p_phn_h_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1118: ,p_phn_w_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1119: ,p_phn_w_date_from IN per_phones.date_from%TYPE
1120: ,p_phn_w_date_to IN per_phones.date_to%TYPE
1121: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
1122: ,p_phn_w_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE

Line 1119: ,p_phn_w_date_from IN per_phones.date_from%TYPE

1115: ,p_phn_h_date_to IN per_phones.date_to%TYPE
1116: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
1117: ,p_phn_h_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1118: ,p_phn_w_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1119: ,p_phn_w_date_from IN per_phones.date_from%TYPE
1120: ,p_phn_w_date_to IN per_phones.date_to%TYPE
1121: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
1122: ,p_phn_w_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1123: ,p_phn_m_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE

Line 1120: ,p_phn_w_date_to IN per_phones.date_to%TYPE

1116: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
1117: ,p_phn_h_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1118: ,p_phn_w_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1119: ,p_phn_w_date_from IN per_phones.date_from%TYPE
1120: ,p_phn_w_date_to IN per_phones.date_to%TYPE
1121: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
1122: ,p_phn_w_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1123: ,p_phn_m_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1124: ,p_phn_m_date_from IN per_phones.date_from%TYPE

Line 1121: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE

1117: ,p_phn_h_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1118: ,p_phn_w_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1119: ,p_phn_w_date_from IN per_phones.date_from%TYPE
1120: ,p_phn_w_date_to IN per_phones.date_to%TYPE
1121: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
1122: ,p_phn_w_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1123: ,p_phn_m_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1124: ,p_phn_m_date_from IN per_phones.date_from%TYPE
1125: ,p_phn_m_date_to IN per_phones.date_to%TYPE

Line 1122: ,p_phn_w_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE

1118: ,p_phn_w_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1119: ,p_phn_w_date_from IN per_phones.date_from%TYPE
1120: ,p_phn_w_date_to IN per_phones.date_to%TYPE
1121: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
1122: ,p_phn_w_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1123: ,p_phn_m_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1124: ,p_phn_m_date_from IN per_phones.date_from%TYPE
1125: ,p_phn_m_date_to IN per_phones.date_to%TYPE
1126: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE

Line 1123: ,p_phn_m_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE

1119: ,p_phn_w_date_from IN per_phones.date_from%TYPE
1120: ,p_phn_w_date_to IN per_phones.date_to%TYPE
1121: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
1122: ,p_phn_w_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1123: ,p_phn_m_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1124: ,p_phn_m_date_from IN per_phones.date_from%TYPE
1125: ,p_phn_m_date_to IN per_phones.date_to%TYPE
1126: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
1127: ,p_phn_m_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE

Line 1124: ,p_phn_m_date_from IN per_phones.date_from%TYPE

1120: ,p_phn_w_date_to IN per_phones.date_to%TYPE
1121: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
1122: ,p_phn_w_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1123: ,p_phn_m_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1124: ,p_phn_m_date_from IN per_phones.date_from%TYPE
1125: ,p_phn_m_date_to IN per_phones.date_to%TYPE
1126: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
1127: ,p_phn_m_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1128: ,p_phn_hf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE

Line 1125: ,p_phn_m_date_to IN per_phones.date_to%TYPE

1121: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
1122: ,p_phn_w_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1123: ,p_phn_m_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1124: ,p_phn_m_date_from IN per_phones.date_from%TYPE
1125: ,p_phn_m_date_to IN per_phones.date_to%TYPE
1126: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
1127: ,p_phn_m_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1128: ,p_phn_hf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1129: ,p_phn_hf_date_from IN per_phones.date_from%TYPE

Line 1126: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE

1122: ,p_phn_w_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1123: ,p_phn_m_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1124: ,p_phn_m_date_from IN per_phones.date_from%TYPE
1125: ,p_phn_m_date_to IN per_phones.date_to%TYPE
1126: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
1127: ,p_phn_m_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1128: ,p_phn_hf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1129: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
1130: ,p_phn_hf_date_to IN per_phones.date_to%TYPE

Line 1127: ,p_phn_m_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE

1123: ,p_phn_m_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1124: ,p_phn_m_date_from IN per_phones.date_from%TYPE
1125: ,p_phn_m_date_to IN per_phones.date_to%TYPE
1126: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
1127: ,p_phn_m_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1128: ,p_phn_hf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1129: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
1130: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
1131: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE

Line 1128: ,p_phn_hf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE

1124: ,p_phn_m_date_from IN per_phones.date_from%TYPE
1125: ,p_phn_m_date_to IN per_phones.date_to%TYPE
1126: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
1127: ,p_phn_m_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1128: ,p_phn_hf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1129: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
1130: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
1131: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
1132: ,p_phn_hf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE

Line 1129: ,p_phn_hf_date_from IN per_phones.date_from%TYPE

1125: ,p_phn_m_date_to IN per_phones.date_to%TYPE
1126: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
1127: ,p_phn_m_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1128: ,p_phn_hf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1129: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
1130: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
1131: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
1132: ,p_phn_hf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1133: ,p_phn_wf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE

Line 1130: ,p_phn_hf_date_to IN per_phones.date_to%TYPE

1126: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
1127: ,p_phn_m_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1128: ,p_phn_hf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1129: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
1130: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
1131: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
1132: ,p_phn_hf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1133: ,p_phn_wf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1134: ,p_phn_wf_date_from IN per_phones.date_from%TYPE

Line 1131: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE

1127: ,p_phn_m_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1128: ,p_phn_hf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1129: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
1130: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
1131: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
1132: ,p_phn_hf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1133: ,p_phn_wf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1134: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
1135: ,p_phn_wf_date_to IN per_phones.date_to%TYPE

Line 1132: ,p_phn_hf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE

1128: ,p_phn_hf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1129: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
1130: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
1131: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
1132: ,p_phn_hf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1133: ,p_phn_wf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1134: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
1135: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
1136: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE

Line 1133: ,p_phn_wf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE

1129: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
1130: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
1131: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
1132: ,p_phn_hf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1133: ,p_phn_wf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1134: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
1135: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
1136: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
1137: ,p_phn_wf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE

Line 1134: ,p_phn_wf_date_from IN per_phones.date_from%TYPE

1130: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
1131: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
1132: ,p_phn_hf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1133: ,p_phn_wf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1134: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
1135: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
1136: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
1137: ,p_phn_wf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1138: ,p_pay_proposal_id IN OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE

Line 1135: ,p_phn_wf_date_to IN per_phones.date_to%TYPE

1131: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
1132: ,p_phn_hf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1133: ,p_phn_wf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1134: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
1135: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
1136: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
1137: ,p_phn_wf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1138: ,p_pay_proposal_id IN OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
1139: ,p_change_date IN per_pay_proposals.change_date%TYPE

Line 1136: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE

1132: ,p_phn_hf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1133: ,p_phn_wf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1134: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
1135: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
1136: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
1137: ,p_phn_wf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1138: ,p_pay_proposal_id IN OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
1139: ,p_change_date IN per_pay_proposals.change_date%TYPE
1140: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE

Line 1137: ,p_phn_wf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE

1133: ,p_phn_wf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1134: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
1135: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
1136: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
1137: ,p_phn_wf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1138: ,p_pay_proposal_id IN OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
1139: ,p_change_date IN per_pay_proposals.change_date%TYPE
1140: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE
1141: ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE

Line 1477: ,p_phn_h_phone_id per_phones.phone_id%TYPE

1473: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
1474: ,p_pds_hire_date per_periods_of_service.date_start%TYPE
1475: ,p_address_id per_addresses.address_id%TYPE
1476: ,p_addr_object_version_number per_addresses.object_version_number%TYPE
1477: ,p_phn_h_phone_id per_phones.phone_id%TYPE
1478: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE
1479: ,p_phn_w_phone_id per_phones.phone_id%TYPE
1480: ,p_phn_w_object_version_number per_phones.object_version_number%TYPE
1481: ,p_phn_m_phone_id per_phones.phone_id%TYPE

Line 1478: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE

1474: ,p_pds_hire_date per_periods_of_service.date_start%TYPE
1475: ,p_address_id per_addresses.address_id%TYPE
1476: ,p_addr_object_version_number per_addresses.object_version_number%TYPE
1477: ,p_phn_h_phone_id per_phones.phone_id%TYPE
1478: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE
1479: ,p_phn_w_phone_id per_phones.phone_id%TYPE
1480: ,p_phn_w_object_version_number per_phones.object_version_number%TYPE
1481: ,p_phn_m_phone_id per_phones.phone_id%TYPE
1482: ,p_phn_m_object_version_number per_phones.object_version_number%TYPE

Line 1479: ,p_phn_w_phone_id per_phones.phone_id%TYPE

1475: ,p_address_id per_addresses.address_id%TYPE
1476: ,p_addr_object_version_number per_addresses.object_version_number%TYPE
1477: ,p_phn_h_phone_id per_phones.phone_id%TYPE
1478: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE
1479: ,p_phn_w_phone_id per_phones.phone_id%TYPE
1480: ,p_phn_w_object_version_number per_phones.object_version_number%TYPE
1481: ,p_phn_m_phone_id per_phones.phone_id%TYPE
1482: ,p_phn_m_object_version_number per_phones.object_version_number%TYPE
1483: ,p_phn_hf_phone_id per_phones.phone_id%TYPE

Line 1480: ,p_phn_w_object_version_number per_phones.object_version_number%TYPE

1476: ,p_addr_object_version_number per_addresses.object_version_number%TYPE
1477: ,p_phn_h_phone_id per_phones.phone_id%TYPE
1478: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE
1479: ,p_phn_w_phone_id per_phones.phone_id%TYPE
1480: ,p_phn_w_object_version_number per_phones.object_version_number%TYPE
1481: ,p_phn_m_phone_id per_phones.phone_id%TYPE
1482: ,p_phn_m_object_version_number per_phones.object_version_number%TYPE
1483: ,p_phn_hf_phone_id per_phones.phone_id%TYPE
1484: ,p_phn_hf_object_version_number per_phones.object_version_number%TYPE

Line 1481: ,p_phn_m_phone_id per_phones.phone_id%TYPE

1477: ,p_phn_h_phone_id per_phones.phone_id%TYPE
1478: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE
1479: ,p_phn_w_phone_id per_phones.phone_id%TYPE
1480: ,p_phn_w_object_version_number per_phones.object_version_number%TYPE
1481: ,p_phn_m_phone_id per_phones.phone_id%TYPE
1482: ,p_phn_m_object_version_number per_phones.object_version_number%TYPE
1483: ,p_phn_hf_phone_id per_phones.phone_id%TYPE
1484: ,p_phn_hf_object_version_number per_phones.object_version_number%TYPE
1485: ,p_phn_wf_phone_id per_phones.phone_id%TYPE

Line 1482: ,p_phn_m_object_version_number per_phones.object_version_number%TYPE

1478: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE
1479: ,p_phn_w_phone_id per_phones.phone_id%TYPE
1480: ,p_phn_w_object_version_number per_phones.object_version_number%TYPE
1481: ,p_phn_m_phone_id per_phones.phone_id%TYPE
1482: ,p_phn_m_object_version_number per_phones.object_version_number%TYPE
1483: ,p_phn_hf_phone_id per_phones.phone_id%TYPE
1484: ,p_phn_hf_object_version_number per_phones.object_version_number%TYPE
1485: ,p_phn_wf_phone_id per_phones.phone_id%TYPE
1486: ,p_phn_wf_object_version_number per_phones.object_version_number%TYPE

Line 1483: ,p_phn_hf_phone_id per_phones.phone_id%TYPE

1479: ,p_phn_w_phone_id per_phones.phone_id%TYPE
1480: ,p_phn_w_object_version_number per_phones.object_version_number%TYPE
1481: ,p_phn_m_phone_id per_phones.phone_id%TYPE
1482: ,p_phn_m_object_version_number per_phones.object_version_number%TYPE
1483: ,p_phn_hf_phone_id per_phones.phone_id%TYPE
1484: ,p_phn_hf_object_version_number per_phones.object_version_number%TYPE
1485: ,p_phn_wf_phone_id per_phones.phone_id%TYPE
1486: ,p_phn_wf_object_version_number per_phones.object_version_number%TYPE
1487: ,p_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE

Line 1484: ,p_phn_hf_object_version_number per_phones.object_version_number%TYPE

1480: ,p_phn_w_object_version_number per_phones.object_version_number%TYPE
1481: ,p_phn_m_phone_id per_phones.phone_id%TYPE
1482: ,p_phn_m_object_version_number per_phones.object_version_number%TYPE
1483: ,p_phn_hf_phone_id per_phones.phone_id%TYPE
1484: ,p_phn_hf_object_version_number per_phones.object_version_number%TYPE
1485: ,p_phn_wf_phone_id per_phones.phone_id%TYPE
1486: ,p_phn_wf_object_version_number per_phones.object_version_number%TYPE
1487: ,p_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE
1488: ,p_pyp_object_version_number per_pay_proposals.object_version_number%TYPE

Line 1485: ,p_phn_wf_phone_id per_phones.phone_id%TYPE

1481: ,p_phn_m_phone_id per_phones.phone_id%TYPE
1482: ,p_phn_m_object_version_number per_phones.object_version_number%TYPE
1483: ,p_phn_hf_phone_id per_phones.phone_id%TYPE
1484: ,p_phn_hf_object_version_number per_phones.object_version_number%TYPE
1485: ,p_phn_wf_phone_id per_phones.phone_id%TYPE
1486: ,p_phn_wf_object_version_number per_phones.object_version_number%TYPE
1487: ,p_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE
1488: ,p_pyp_object_version_number per_pay_proposals.object_version_number%TYPE
1489: ,p_deployment_factor_id per_deployment_factors.deployment_factor_id%TYPE

Line 1486: ,p_phn_wf_object_version_number per_phones.object_version_number%TYPE

1482: ,p_phn_m_object_version_number per_phones.object_version_number%TYPE
1483: ,p_phn_hf_phone_id per_phones.phone_id%TYPE
1484: ,p_phn_hf_object_version_number per_phones.object_version_number%TYPE
1485: ,p_phn_wf_phone_id per_phones.phone_id%TYPE
1486: ,p_phn_wf_object_version_number per_phones.object_version_number%TYPE
1487: ,p_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE
1488: ,p_pyp_object_version_number per_pay_proposals.object_version_number%TYPE
1489: ,p_deployment_factor_id per_deployment_factors.deployment_factor_id%TYPE
1490: ,p_dpf_object_version_number per_deployment_factors.object_version_number%TYPE