APPS.PER_ASSIGNMENTS_F3_PKG dependencies on PER_PAY_PROPOSALS

Line 456: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_Id%TYPE;

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

Line 457: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;

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

Line 458: l_del_proposal_change_dt per_pay_proposals.change_date%type;

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

Line 460: l_del_bg_id per_pay_Proposals.business_group_id%type;

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

Line 526: From Per_Pay_Proposals

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