APPS.PER_SALADMIN_UTILITY dependencies on PER_PAY_PROPOSAL_COMPONENTS

Line 1030: l_component_id per_pay_proposal_components.component_id%TYPE;

1026: l_creator_id number;
1027: l_proposal_rec per_pay_proposals%ROWTYPE;
1028: l_date_to date;
1029:
1030: l_component_id per_pay_proposal_components.component_id%TYPE;
1031: l_object_version_number per_pay_proposal_components.object_version_number%TYPE;
1032: l_proposal_comp_rec per_pay_proposal_components%ROWTYPE;
1033:
1034: l_pay_proposal_id NUMBER;

Line 1031: l_object_version_number per_pay_proposal_components.object_version_number%TYPE;

1027: l_proposal_rec per_pay_proposals%ROWTYPE;
1028: l_date_to date;
1029:
1030: l_component_id per_pay_proposal_components.component_id%TYPE;
1031: l_object_version_number per_pay_proposal_components.object_version_number%TYPE;
1032: l_proposal_comp_rec per_pay_proposal_components%ROWTYPE;
1033:
1034: l_pay_proposal_id NUMBER;
1035: l_ovn NUMBER;

Line 1032: l_proposal_comp_rec per_pay_proposal_components%ROWTYPE;

1028: l_date_to date;
1029:
1030: l_component_id per_pay_proposal_components.component_id%TYPE;
1031: l_object_version_number per_pay_proposal_components.object_version_number%TYPE;
1032: l_proposal_comp_rec per_pay_proposal_components%ROWTYPE;
1033:
1034: l_pay_proposal_id NUMBER;
1035: l_ovn NUMBER;
1036: l_inv_next_sal_date_warning BOOLEAN;

Line 1058: select * from per_pay_proposal_components

1054: where ASSIGNMENT_ID=c_assignment_id
1055: and pay_proposal_id=c_pay_proposal_id;
1056:
1057: cursor csr_proposal_components(c_pay_proposal_id in number) is
1058: select * from per_pay_proposal_components
1059: where pay_proposal_id=c_pay_proposal_id;
1060:
1061: begin
1062: