APPS.PER_ASSIGNMENTS_F3_PKG dependencies on PER_PAY_PROPOSALS

Line 459: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_Id%TYPE;

455: l_element_entry_id number;
456: l_entries_changed_warning varchar2(1) := 'N';
457: l_pay_basis_id number; --fix for bug 4764140
458: --
459: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_Id%TYPE;
460: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
461: l_del_proposal_change_dt per_pay_proposals.change_date%type;
462: l_del_warn boolean;
463: l_del_bg_id per_pay_Proposals.business_group_id%type;

Line 460: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;

456: l_entries_changed_warning varchar2(1) := 'N';
457: l_pay_basis_id number; --fix for bug 4764140
458: --
459: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_Id%TYPE;
460: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
461: l_del_proposal_change_dt per_pay_proposals.change_date%type;
462: l_del_warn boolean;
463: l_del_bg_id per_pay_Proposals.business_group_id%type;
464: l_inv_next_sal_date_warning boolean;

Line 461: l_del_proposal_change_dt per_pay_proposals.change_date%type;

457: l_pay_basis_id number; --fix for bug 4764140
458: --
459: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_Id%TYPE;
460: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
461: l_del_proposal_change_dt per_pay_proposals.change_date%type;
462: l_del_warn boolean;
463: l_del_bg_id per_pay_Proposals.business_group_id%type;
464: l_inv_next_sal_date_warning boolean;
465: l_proposed_salary_warning boolean;

Line 463: l_del_bg_id per_pay_Proposals.business_group_id%type;

459: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_Id%TYPE;
460: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
461: l_del_proposal_change_dt per_pay_proposals.change_date%type;
462: l_del_warn boolean;
463: l_del_bg_id per_pay_Proposals.business_group_id%type;
464: l_inv_next_sal_date_warning boolean;
465: l_proposed_salary_warning boolean;
466: l_approved_warning boolean;
467: l_payroll_warning boolean;

Line 529: From Per_Pay_Proposals

525: --
526: --
527: Cursor Proposal_Dtls is
528: Select Pay_Proposal_Id, Object_Version_Number,business_group_id,change_date
529: From Per_Pay_Proposals
530: where assignment_id = p_ass_id
531: and change_date <= p_val_st_date
532: and nvl(date_to,to_date('31/12/4712','dd/mm/yyyy')) >= p_val_st_date;
533: