eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PYP_BUS dependencies on PER_PAY_PROPOSALS

Line 89: p_approved in per_pay_proposals.approved%TYPE

85: (p_assignment_id in number,
86: p_pay_proposal_id in number,
87: p_change_date in date,
88: p_date_to in date,
89: p_approved in per_pay_proposals.approved%TYPE
90: )
91: IS
92: --
93: -- Cursor to find legislation code

Line 97: from per_pay_proposals

93: -- Cursor to find legislation code
94: --
95: cursor csr_next_proposed_date is
96: select min(change_date)
97: from per_pay_proposals
98: where assignment_id = p_assignment_id
99: and change_date > p_change_date
100: and approved = 'N'
101: and pay_proposal_id <> p_pay_proposal_id;

Line 105: from per_pay_proposals

101: and pay_proposal_id <> p_pay_proposal_id;
102:
103: cursor csr_next_approved_date is
104: select min(change_date)
105: from per_pay_proposals
106: where assignment_id = p_assignment_id
107: and change_date > p_change_date
108: and approved = 'Y'
109: and pay_proposal_id <> p_pay_proposal_id;

Line 156: l_last_change_date per_pay_proposals.last_change_date%TYPE;

152: procedure gen_last_change_date
153: (p_rec in out nocopy per_pyp_shd.g_rec_type) is
154: --
155: l_proc varchar2(72) := g_package || 'gen_last_change_date';
156: l_last_change_date per_pay_proposals.last_change_date%TYPE;
157: --
158: -- define a cusor to determine wheather another proposal exists or not
159: --
160: Cursor csr_last_change_date is

Line 162: from per_pay_proposals pro

158: -- define a cusor to determine wheather another proposal exists or not
159: --
160: Cursor csr_last_change_date is
161: select max(pro.change_date)
162: from per_pay_proposals pro
163: where pro.assignment_id = p_rec.assignment_id
164: and pro.change_date 165:
166: --

Line 226: (p_assignment_id in per_pay_proposals.assignment_id%TYPE

222: -- Internal Table Handler Use Only.
223: --
224: --
225: procedure chk_pay_basis_change_date
226: (p_assignment_id in per_pay_proposals.assignment_id%TYPE
227: ,p_change_date in per_pay_proposals.change_date%TYPE
228: ) is
229: --
230: -- Cursor to check that there is at least one approved salary proposal

Line 227: ,p_change_date in per_pay_proposals.change_date%TYPE

223: --
224: --
225: procedure chk_pay_basis_change_date
226: (p_assignment_id in per_pay_proposals.assignment_id%TYPE
227: ,p_change_date in per_pay_proposals.change_date%TYPE
228: ) is
229: --
230: -- Cursor to check that there is at least one approved salary proposal
231: -- for this assignment

Line 235: from per_pay_proposals

231: -- for this assignment
232: --
233: cursor csr_first_proposal is
234: select null
235: from per_pay_proposals
236: where assignment_id = p_assignment_id
237: and approved = 'Y';
238: --
239: -- cursor which checks whether there is an open salary element.

Line 499: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE

495: -- Internal Table Handler Use Only.
496: --
497: procedure chk_access
498: (p_change_date in date
499: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
500: ) is
501: --
502: -- Declare local variables
503: --

Line 610: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE

606: --
607: --
608:
609: procedure chk_assignment_id_change_date
610: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
611: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
612: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
613: ,p_change_date in per_pay_proposals.change_date%TYPE
614: ,p_payroll_warning out nocopy boolean

Line 611: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE

607: --
608:
609: procedure chk_assignment_id_change_date
610: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
611: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
612: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
613: ,p_change_date in per_pay_proposals.change_date%TYPE
614: ,p_payroll_warning out nocopy boolean
615: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

Line 612: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE

608:
609: procedure chk_assignment_id_change_date
610: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
611: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
612: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
613: ,p_change_date in per_pay_proposals.change_date%TYPE
614: ,p_payroll_warning out nocopy boolean
615: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
616: )

Line 613: ,p_change_date in per_pay_proposals.change_date%TYPE

609: procedure chk_assignment_id_change_date
610: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
611: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
612: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
613: ,p_change_date in per_pay_proposals.change_date%TYPE
614: ,p_payroll_warning out nocopy boolean
615: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
616: )
617: is

Line 615: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

611: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
612: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
613: ,p_change_date in per_pay_proposals.change_date%TYPE
614: ,p_payroll_warning out nocopy boolean
615: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
616: )
617: is
618: --
619: l_exists varchar2(1);

Line 628: l_change_date per_pay_proposals.change_date%TYPE;

624: l_assginment_id per_all_assignments_f.assignment_id%TYPE;
625: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
626: l_system_status per_assignment_status_types.per_system_status%TYPE;
627: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
628: l_change_date per_pay_proposals.change_date%TYPE;
629: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
630: --
631: --
632: -- Cursor to check existence of pay proposal with the same change date for the

Line 638: from per_pay_proposals

634: -- Also to check the latest proposal change_date for the assignment.
635: --
636: cursor csr_dup_change_date is
637: select null
638: from per_pay_proposals
639: where assignment_id = p_assignment_id
640: and business_group_id + 0 = p_business_group_id
641: and change_date = p_change_date
642: and pay_proposal_id <> nvl(p_pay_proposal_id,-1);

Line 646: from per_pay_proposals

642: and pay_proposal_id <> nvl(p_pay_proposal_id,-1);
643: --
644: cursor csr_last_change_date is
645: select max(change_date)
646: from per_pay_proposals
647: where assignment_id = p_assignment_id
648: and business_group_id + 0 = p_business_group_id
649: and pay_proposal_id<>nvl(p_pay_proposal_id,-1);
650: --

Line 655: from per_pay_proposals

651: -- Define a cursor to check whether other proposals exist.
652: --
653: Cursor csr_other_proposals_exist is
654: select null
655: from per_pay_proposals
656: where assignment_id = p_assignment_id
657: and approved = 'N'
658: and pay_proposal_id<>nvl(p_pay_proposal_id,-1);
659: --

Line 894: (p_change_date in per_pay_proposals.change_date%TYPE

890: -- Internal Table Handler Use Only.
891: --
892: --
893: function derive_next_sal_perf_date
894: (p_change_date in per_pay_proposals.change_date%TYPE
895: ,p_period in per_all_assignments_f.sal_review_period%TYPE
896: ,p_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE
897: )
898: Return Date is

Line 1001: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE

997: -- Internal Table Handler Use Only.
998: --
999: --
1000: procedure chk_next_sal_review_date
1001: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
1002: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1003: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
1004: ,p_change_date in per_pay_proposals.change_date%TYPE
1005: ,p_next_sal_review_date in per_pay_proposals.next_sal_review_date%TYPE

Line 1002: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE

998: --
999: --
1000: procedure chk_next_sal_review_date
1001: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
1002: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1003: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
1004: ,p_change_date in per_pay_proposals.change_date%TYPE
1005: ,p_next_sal_review_date in per_pay_proposals.next_sal_review_date%TYPE
1006: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

Line 1003: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE

999: --
1000: procedure chk_next_sal_review_date
1001: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
1002: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1003: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
1004: ,p_change_date in per_pay_proposals.change_date%TYPE
1005: ,p_next_sal_review_date in per_pay_proposals.next_sal_review_date%TYPE
1006: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
1007: ,p_inv_next_sal_date_warning out nocopy boolean

Line 1004: ,p_change_date in per_pay_proposals.change_date%TYPE

1000: procedure chk_next_sal_review_date
1001: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
1002: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1003: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
1004: ,p_change_date in per_pay_proposals.change_date%TYPE
1005: ,p_next_sal_review_date in per_pay_proposals.next_sal_review_date%TYPE
1006: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
1007: ,p_inv_next_sal_date_warning out nocopy boolean
1008: )

Line 1005: ,p_next_sal_review_date in per_pay_proposals.next_sal_review_date%TYPE

1001: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
1002: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1003: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
1004: ,p_change_date in per_pay_proposals.change_date%TYPE
1005: ,p_next_sal_review_date in per_pay_proposals.next_sal_review_date%TYPE
1006: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
1007: ,p_inv_next_sal_date_warning out nocopy boolean
1008: )
1009: is

Line 1006: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

1002: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1003: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
1004: ,p_change_date in per_pay_proposals.change_date%TYPE
1005: ,p_next_sal_review_date in per_pay_proposals.next_sal_review_date%TYPE
1006: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
1007: ,p_inv_next_sal_date_warning out nocopy boolean
1008: )
1009: is
1010: --

Line 1143: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE

1139: -- Internal Table Handler Use Only.
1140: --
1141: --
1142: procedure chk_chg_next_sal_review_date
1143: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
1144: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1145: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
1146: ,p_change_date in per_pay_proposals.change_date%TYPE
1147: ,p_next_sal_review_date in out nocopy per_pay_proposals.next_sal_review_date%TYPE

Line 1144: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE

1140: --
1141: --
1142: procedure chk_chg_next_sal_review_date
1143: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
1144: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1145: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
1146: ,p_change_date in per_pay_proposals.change_date%TYPE
1147: ,p_next_sal_review_date in out nocopy per_pay_proposals.next_sal_review_date%TYPE
1148: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

Line 1145: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE

1141: --
1142: procedure chk_chg_next_sal_review_date
1143: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
1144: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1145: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
1146: ,p_change_date in per_pay_proposals.change_date%TYPE
1147: ,p_next_sal_review_date in out nocopy per_pay_proposals.next_sal_review_date%TYPE
1148: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
1149: ,p_inv_next_sal_date_warning out nocopy boolean

Line 1146: ,p_change_date in per_pay_proposals.change_date%TYPE

1142: procedure chk_chg_next_sal_review_date
1143: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
1144: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1145: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
1146: ,p_change_date in per_pay_proposals.change_date%TYPE
1147: ,p_next_sal_review_date in out nocopy per_pay_proposals.next_sal_review_date%TYPE
1148: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
1149: ,p_inv_next_sal_date_warning out nocopy boolean
1150: )

Line 1147: ,p_next_sal_review_date in out nocopy per_pay_proposals.next_sal_review_date%TYPE

1143: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
1144: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1145: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
1146: ,p_change_date in per_pay_proposals.change_date%TYPE
1147: ,p_next_sal_review_date in out nocopy per_pay_proposals.next_sal_review_date%TYPE
1148: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
1149: ,p_inv_next_sal_date_warning out nocopy boolean
1150: )
1151: is

Line 1148: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

1144: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1145: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
1146: ,p_change_date in per_pay_proposals.change_date%TYPE
1147: ,p_next_sal_review_date in out nocopy per_pay_proposals.next_sal_review_date%TYPE
1148: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
1149: ,p_inv_next_sal_date_warning out nocopy boolean
1150: )
1151: is
1152: --

Line 1297: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE

1293: -- Access Status
1294: -- Internal Table Handler Use Only.
1295: --
1296: procedure chk_multiple_components
1297: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
1298: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
1299: ,p_change_date in per_pay_proposals.change_date%TYPE
1300: ,p_multiple_components in per_pay_proposals.multiple_components%TYPE
1301: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

Line 1298: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE

1294: -- Internal Table Handler Use Only.
1295: --
1296: procedure chk_multiple_components
1297: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
1298: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
1299: ,p_change_date in per_pay_proposals.change_date%TYPE
1300: ,p_multiple_components in per_pay_proposals.multiple_components%TYPE
1301: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
1302: )

Line 1299: ,p_change_date in per_pay_proposals.change_date%TYPE

1295: --
1296: procedure chk_multiple_components
1297: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
1298: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
1299: ,p_change_date in per_pay_proposals.change_date%TYPE
1300: ,p_multiple_components in per_pay_proposals.multiple_components%TYPE
1301: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
1302: )
1303: is

Line 1300: ,p_multiple_components in per_pay_proposals.multiple_components%TYPE

1296: procedure chk_multiple_components
1297: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
1298: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
1299: ,p_change_date in per_pay_proposals.change_date%TYPE
1300: ,p_multiple_components in per_pay_proposals.multiple_components%TYPE
1301: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
1302: )
1303: is
1304: --

Line 1301: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

1297: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
1298: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
1299: ,p_change_date in per_pay_proposals.change_date%TYPE
1300: ,p_multiple_components in per_pay_proposals.multiple_components%TYPE
1301: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
1302: )
1303: is
1304: --
1305: l_proc varchar2(72):= g_package||'chk_multiple_components';

Line 1313: from per_pay_proposals pro,

1309: -- Cursor to check for the first salary proposals.
1310: --
1311: Cursor csr_is_first_proposal is
1312: select null
1313: from per_pay_proposals pro,
1314: per_all_assignments_f ass
1315: where pro.assignment_id = p_assignment_id
1316: and ass.assignment_id = pro.assignment_id
1317: and p_change_date between ass.effective_start_date

Line 1421: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE

1417: -- Internal Table Handler Use Only.
1418: --
1419: --
1420: procedure chk_proposal_reason
1421: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
1422: ,p_change_date in per_pay_proposals.change_date%TYPE
1423: ,p_proposal_reason in per_pay_proposals.proposal_reason%TYPE
1424: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
1425: )

Line 1422: ,p_change_date in per_pay_proposals.change_date%TYPE

1418: --
1419: --
1420: procedure chk_proposal_reason
1421: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
1422: ,p_change_date in per_pay_proposals.change_date%TYPE
1423: ,p_proposal_reason in per_pay_proposals.proposal_reason%TYPE
1424: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
1425: )
1426: is

Line 1423: ,p_proposal_reason in per_pay_proposals.proposal_reason%TYPE

1419: --
1420: procedure chk_proposal_reason
1421: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
1422: ,p_change_date in per_pay_proposals.change_date%TYPE
1423: ,p_proposal_reason in per_pay_proposals.proposal_reason%TYPE
1424: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
1425: )
1426: is
1427: --

Line 1424: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

1420: procedure chk_proposal_reason
1421: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
1422: ,p_change_date in per_pay_proposals.change_date%TYPE
1423: ,p_proposal_reason in per_pay_proposals.proposal_reason%TYPE
1424: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
1425: )
1426: is
1427: --
1428: l_proc varchar2(72):= g_package||'chk_proposal_reason';

Line 1506: (p_assignment_id in per_pay_proposals.assignment_id%TYPE

1502: -- Internal Table Handler USe only
1503: --
1504: --
1505: procedure is_salary_in_range
1506: (p_assignment_id in per_pay_proposals.assignment_id%TYPE
1507: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1508: ,p_change_date in per_pay_proposals.change_date%TYPE
1509: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
1510: ,p_proposed_salary_warning out nocopy boolean

Line 1507: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE

1503: --
1504: --
1505: procedure is_salary_in_range
1506: (p_assignment_id in per_pay_proposals.assignment_id%TYPE
1507: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1508: ,p_change_date in per_pay_proposals.change_date%TYPE
1509: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
1510: ,p_proposed_salary_warning out nocopy boolean
1511: ) is

Line 1508: ,p_change_date in per_pay_proposals.change_date%TYPE

1504: --
1505: procedure is_salary_in_range
1506: (p_assignment_id in per_pay_proposals.assignment_id%TYPE
1507: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1508: ,p_change_date in per_pay_proposals.change_date%TYPE
1509: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
1510: ,p_proposed_salary_warning out nocopy boolean
1511: ) is
1512:

Line 1509: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE

1505: procedure is_salary_in_range
1506: (p_assignment_id in per_pay_proposals.assignment_id%TYPE
1507: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1508: ,p_change_date in per_pay_proposals.change_date%TYPE
1509: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
1510: ,p_proposed_salary_warning out nocopy boolean
1511: ) is
1512:
1513: l_proc varchar2(70):= g_package || 'is_salary_in_range';

Line 1619: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE

1615: ,p_position_id in per_all_assignments_f.position_id%TYPE
1616: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1617: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1618: ,p_frequency in per_all_assignments_f.frequency%TYPE
1619: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1620: ,p_change_date in per_pay_proposals.change_date%TYPE
1621: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
1622: ,p_prop_salary_link_warning out nocopy boolean
1623: ,p_prop_salary_ele_warning out nocopy boolean

Line 1620: ,p_change_date in per_pay_proposals.change_date%TYPE

1616: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1617: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1618: ,p_frequency in per_all_assignments_f.frequency%TYPE
1619: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1620: ,p_change_date in per_pay_proposals.change_date%TYPE
1621: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
1622: ,p_prop_salary_link_warning out nocopy boolean
1623: ,p_prop_salary_ele_warning out nocopy boolean
1624: ,p_prop_salary_grade_warning out nocopy boolean

Line 1621: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE

1617: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1618: ,p_frequency in per_all_assignments_f.frequency%TYPE
1619: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1620: ,p_change_date in per_pay_proposals.change_date%TYPE
1621: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
1622: ,p_prop_salary_link_warning out nocopy boolean
1623: ,p_prop_salary_ele_warning out nocopy boolean
1624: ,p_prop_salary_grade_warning out nocopy boolean
1625:

Line 1701: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE

1697: ,p_position_id in per_all_assignments_f.position_id%TYPE
1698: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1699: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1700: ,p_frequency in per_all_assignments_f.frequency%TYPE
1701: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1702: ,p_change_date in per_pay_proposals.change_date%TYPE
1703: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
1704: ,p_prop_salary_link_warning out nocopy boolean
1705: ,p_prop_salary_ele_warning out nocopy boolean

Line 1702: ,p_change_date in per_pay_proposals.change_date%TYPE

1698: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1699: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1700: ,p_frequency in per_all_assignments_f.frequency%TYPE
1701: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1702: ,p_change_date in per_pay_proposals.change_date%TYPE
1703: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
1704: ,p_prop_salary_link_warning out nocopy boolean
1705: ,p_prop_salary_ele_warning out nocopy boolean
1706: ,p_prop_salary_grade_warning out nocopy boolean

Line 1703: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE

1699: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1700: ,p_frequency in per_all_assignments_f.frequency%TYPE
1701: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1702: ,p_change_date in per_pay_proposals.change_date%TYPE
1703: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
1704: ,p_prop_salary_link_warning out nocopy boolean
1705: ,p_prop_salary_ele_warning out nocopy boolean
1706: ,p_prop_salary_grade_warning out nocopy boolean
1707: --added by vkodedal bug#8452388

Line 2070: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE

2066: -- Access Status
2067: -- Internal Table Handler Use Only.
2068: --
2069: procedure chk_proposed_salary
2070: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
2071: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
2072: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
2073: ,p_change_date in per_pay_proposals.change_date%TYPE
2074: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE

Line 2071: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE

2067: -- Internal Table Handler Use Only.
2068: --
2069: procedure chk_proposed_salary
2070: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
2071: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
2072: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
2073: ,p_change_date in per_pay_proposals.change_date%TYPE
2074: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
2075: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

Line 2072: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE

2068: --
2069: procedure chk_proposed_salary
2070: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
2071: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
2072: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
2073: ,p_change_date in per_pay_proposals.change_date%TYPE
2074: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
2075: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
2076: ,p_proposed_salary_warning out nocopy boolean

Line 2073: ,p_change_date in per_pay_proposals.change_date%TYPE

2069: procedure chk_proposed_salary
2070: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
2071: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
2072: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
2073: ,p_change_date in per_pay_proposals.change_date%TYPE
2074: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
2075: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
2076: ,p_proposed_salary_warning out nocopy boolean
2077: -- vkodedal 19-feb-2008

Line 2074: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE

2070: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
2071: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
2072: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
2073: ,p_change_date in per_pay_proposals.change_date%TYPE
2074: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
2075: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
2076: ,p_proposed_salary_warning out nocopy boolean
2077: -- vkodedal 19-feb-2008
2078: ,p_multiple_components in per_pay_proposals.multiple_components%TYPE

Line 2075: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

2071: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
2072: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
2073: ,p_change_date in per_pay_proposals.change_date%TYPE
2074: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
2075: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
2076: ,p_proposed_salary_warning out nocopy boolean
2077: -- vkodedal 19-feb-2008
2078: ,p_multiple_components in per_pay_proposals.multiple_components%TYPE
2079: )

Line 2078: ,p_multiple_components in per_pay_proposals.multiple_components%TYPE

2074: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
2075: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
2076: ,p_proposed_salary_warning out nocopy boolean
2077: -- vkodedal 19-feb-2008
2078: ,p_multiple_components in per_pay_proposals.multiple_components%TYPE
2079: )
2080: is
2081:
2082: --

Line 2212: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE

2208: -- Access Status
2209: -- Internal Table Handler Use Only.
2210: --
2211: procedure chk_approved
2212: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
2213: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
2214: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
2215: ,p_change_date in per_pay_proposals.change_date%TYPE
2216: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE

Line 2213: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE

2209: -- Internal Table Handler Use Only.
2210: --
2211: procedure chk_approved
2212: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
2213: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
2214: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
2215: ,p_change_date in per_pay_proposals.change_date%TYPE
2216: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
2217: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

Line 2214: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE

2210: --
2211: procedure chk_approved
2212: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
2213: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
2214: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
2215: ,p_change_date in per_pay_proposals.change_date%TYPE
2216: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
2217: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
2218: ,p_approved in per_pay_proposals.approved%TYPE

Line 2215: ,p_change_date in per_pay_proposals.change_date%TYPE

2211: procedure chk_approved
2212: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
2213: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
2214: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
2215: ,p_change_date in per_pay_proposals.change_date%TYPE
2216: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
2217: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
2218: ,p_approved in per_pay_proposals.approved%TYPE
2219: ,p_approved_warning out nocopy boolean

Line 2216: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE

2212: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
2213: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
2214: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
2215: ,p_change_date in per_pay_proposals.change_date%TYPE
2216: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
2217: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
2218: ,p_approved in per_pay_proposals.approved%TYPE
2219: ,p_approved_warning out nocopy boolean
2220: )

Line 2217: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

2213: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
2214: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
2215: ,p_change_date in per_pay_proposals.change_date%TYPE
2216: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
2217: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
2218: ,p_approved in per_pay_proposals.approved%TYPE
2219: ,p_approved_warning out nocopy boolean
2220: )
2221: is

Line 2218: ,p_approved in per_pay_proposals.approved%TYPE

2214: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
2215: ,p_change_date in per_pay_proposals.change_date%TYPE
2216: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
2217: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
2218: ,p_approved in per_pay_proposals.approved%TYPE
2219: ,p_approved_warning out nocopy boolean
2220: )
2221: is
2222: --

Line 2242: from per_pay_proposals

2238: -- Cursor to get the latest proposals
2239: --
2240: Cursor csr_is_first_proposal is
2241: select null
2242: from per_pay_proposals
2243: where assignment_id = p_assignment_id
2244: and business_group_id + 0 = p_business_group_id
2245: and pay_proposal_id<>nvl(p_pay_proposal_id,-1);
2246: --

Line 2259: from per_pay_proposals

2255: -- Define a cursor to check for approved proposals in the future
2256: --
2257: Cursor csr_future_approved_proposals is
2258: select null
2259: from per_pay_proposals
2260: where assignment_id = p_assignment_id
2261: and approved = 'Y'
2262: and change_date > p_change_date;
2263: --

Line 2456: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE

2452:
2453: --
2454: --
2455: procedure chk_del_pay_proposal
2456: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
2457: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
2458: ,p_salary_warning out nocopy boolean
2459: ) is
2460: --

Line 2457: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

2453: --
2454: --
2455: procedure chk_del_pay_proposal
2456: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
2457: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
2458: ,p_salary_warning out nocopy boolean
2459: ) is
2460: --
2461: l_proc varchar2(72):= g_package||'chk_del_pay_proposal';

Line 2463: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;

2459: ) is
2460: --
2461: l_proc varchar2(72):= g_package||'chk_del_pay_proposal';
2462: l_exists varchar2(1);
2463: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
2464: l_last_change_date per_pay_proposals.change_date%TYPE;
2465: l_assignment_id per_pay_proposals.assignment_id%TYPE;
2466: l_business_group_id per_pay_proposals.business_group_id%TYPE;
2467: l_change_date per_pay_proposals.change_date%TYPE;

Line 2464: l_last_change_date per_pay_proposals.change_date%TYPE;

2460: --
2461: l_proc varchar2(72):= g_package||'chk_del_pay_proposal';
2462: l_exists varchar2(1);
2463: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
2464: l_last_change_date per_pay_proposals.change_date%TYPE;
2465: l_assignment_id per_pay_proposals.assignment_id%TYPE;
2466: l_business_group_id per_pay_proposals.business_group_id%TYPE;
2467: l_change_date per_pay_proposals.change_date%TYPE;
2468: l_approved per_pay_proposals.approved%TYPE;

Line 2465: l_assignment_id per_pay_proposals.assignment_id%TYPE;

2461: l_proc varchar2(72):= g_package||'chk_del_pay_proposal';
2462: l_exists varchar2(1);
2463: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
2464: l_last_change_date per_pay_proposals.change_date%TYPE;
2465: l_assignment_id per_pay_proposals.assignment_id%TYPE;
2466: l_business_group_id per_pay_proposals.business_group_id%TYPE;
2467: l_change_date per_pay_proposals.change_date%TYPE;
2468: l_approved per_pay_proposals.approved%TYPE;
2469: l_multiple_components per_pay_proposals.multiple_components%TYPE;

Line 2466: l_business_group_id per_pay_proposals.business_group_id%TYPE;

2462: l_exists varchar2(1);
2463: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
2464: l_last_change_date per_pay_proposals.change_date%TYPE;
2465: l_assignment_id per_pay_proposals.assignment_id%TYPE;
2466: l_business_group_id per_pay_proposals.business_group_id%TYPE;
2467: l_change_date per_pay_proposals.change_date%TYPE;
2468: l_approved per_pay_proposals.approved%TYPE;
2469: l_multiple_components per_pay_proposals.multiple_components%TYPE;
2470: --

Line 2467: l_change_date per_pay_proposals.change_date%TYPE;

2463: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
2464: l_last_change_date per_pay_proposals.change_date%TYPE;
2465: l_assignment_id per_pay_proposals.assignment_id%TYPE;
2466: l_business_group_id per_pay_proposals.business_group_id%TYPE;
2467: l_change_date per_pay_proposals.change_date%TYPE;
2468: l_approved per_pay_proposals.approved%TYPE;
2469: l_multiple_components per_pay_proposals.multiple_components%TYPE;
2470: --
2471: --

Line 2468: l_approved per_pay_proposals.approved%TYPE;

2464: l_last_change_date per_pay_proposals.change_date%TYPE;
2465: l_assignment_id per_pay_proposals.assignment_id%TYPE;
2466: l_business_group_id per_pay_proposals.business_group_id%TYPE;
2467: l_change_date per_pay_proposals.change_date%TYPE;
2468: l_approved per_pay_proposals.approved%TYPE;
2469: l_multiple_components per_pay_proposals.multiple_components%TYPE;
2470: --
2471: --
2472: -- Define a cursor to get the proposals details

Line 2469: l_multiple_components per_pay_proposals.multiple_components%TYPE;

2465: l_assignment_id per_pay_proposals.assignment_id%TYPE;
2466: l_business_group_id per_pay_proposals.business_group_id%TYPE;
2467: l_change_date per_pay_proposals.change_date%TYPE;
2468: l_approved per_pay_proposals.approved%TYPE;
2469: l_multiple_components per_pay_proposals.multiple_components%TYPE;
2470: --
2471: --
2472: -- Define a cursor to get the proposals details
2473: --

Line 2477: from per_pay_proposals

2473: --
2474: cursor csr_get_pro_detail is
2475: select assignment_id,business_group_id,change_date,
2476: multiple_components,approved
2477: from per_pay_proposals
2478: where pay_proposal_id = p_pay_proposal_id
2479: and object_version_number = p_object_version_number;
2480: --
2481: -- Define a cursor to check for unapproved componnets

Line 2493: from per_pay_proposals

2489: -- Define a cursor which gets the latest approved salary_proposal.
2490: --
2491: cursor csr_get_latest_salary is
2492: select proposed_salary_n
2493: from per_pay_proposals
2494: where assignment_id = l_assignment_id
2495: and change_date < l_change_date
2496: order by change_date desc;
2497: --

Line 2500: from per_pay_proposals

2496: order by change_date desc;
2497: --
2498: Cursor csr_is_latest_proposal is
2499: select max(change_date)
2500: from per_pay_proposals
2501: where assignment_id = l_assignment_id;
2502: --
2503: -- Cursor to check that there are components for the proposal
2504: -- Note: If the proposal has some components, the delete process

Line 2523: per_pyp_shd.constraint_error('PER_PAY_PROPOSALS_PK');

2519: l_change_date,l_multiple_components, l_approved;
2520: if csr_get_pro_detail%notfound then
2521: close csr_get_pro_detail;
2522: hr_utility.set_location(l_proc, 2);
2523: per_pyp_shd.constraint_error('PER_PAY_PROPOSALS_PK');
2524: end if;
2525: close csr_get_pro_detail;
2526: --
2527: -- Check mandatory column from the above cursor are set

Line 2677: (p_change_date in per_pay_proposals.change_date%TYPE,

2673: -- - p_change_date > p_date_to
2674: --
2675: --
2676: procedure chk_date_overlapping
2677: (p_change_date in per_pay_proposals.change_date%TYPE,
2678: p_date_to in per_pay_proposals.date_to%TYPE) is
2679: --
2680: l_proc varchar2(72):= g_package||'chk_date_overlapping';
2681: --

Line 2678: p_date_to in per_pay_proposals.date_to%TYPE) is

2674: --
2675: --
2676: procedure chk_date_overlapping
2677: (p_change_date in per_pay_proposals.change_date%TYPE,
2678: p_date_to in per_pay_proposals.date_to%TYPE) is
2679: --
2680: l_proc varchar2(72):= g_package||'chk_date_overlapping';
2681: --
2682: begin

Line 2719: (p_forced_ranking in per_pay_proposals.forced_ranking%TYPE) is

2715: -- - p_forced_ranking is less than or equal to 0.
2716: --
2717: --
2718: procedure chk_forced_ranking
2719: (p_forced_ranking in per_pay_proposals.forced_ranking%TYPE) is
2720: --
2721: l_proc varchar2(72):= g_package||'chk_forced_ranking';
2722: --
2723: begin

Line 2764: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE

2760: -- Access Status:
2761: -- Internal Table Handler Use Only.
2762: --
2763: procedure chk_performance_review_id
2764: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
2765: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
2766: ,p_performance_review_id in per_pay_proposals.performance_review_id%TYPE
2767: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
2768: )

Line 2765: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE

2761: -- Internal Table Handler Use Only.
2762: --
2763: procedure chk_performance_review_id
2764: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
2765: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
2766: ,p_performance_review_id in per_pay_proposals.performance_review_id%TYPE
2767: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
2768: )
2769: is

Line 2766: ,p_performance_review_id in per_pay_proposals.performance_review_id%TYPE

2762: --
2763: procedure chk_performance_review_id
2764: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
2765: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
2766: ,p_performance_review_id in per_pay_proposals.performance_review_id%TYPE
2767: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
2768: )
2769: is
2770: --

Line 2767: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

2763: procedure chk_performance_review_id
2764: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
2765: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
2766: ,p_performance_review_id in per_pay_proposals.performance_review_id%TYPE
2767: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
2768: )
2769: is
2770: --
2771: l_proc varchar2(72):= g_package||'chk_performance_review_id';

Line 2820: per_pyp_shd.constraint_error('PER_PAY_PROPOSALS_FK4');

2816: fetch csr_chk_performance_review_id into l_exists;
2817: if csr_chk_performance_review_id%notfound then
2818: hr_utility.set_location(l_proc, 15);
2819: close csr_chk_performance_review_id;
2820: per_pyp_shd.constraint_error('PER_PAY_PROPOSALS_FK4');
2821: end if;
2822: --
2823: close csr_chk_performance_review_id;
2824: end if;

Line 2921: ,p_descflex_name => 'PER_PAY_PROPOSALS'

2917: if nvl(fnd_profile.value('FLEXFIELDS:VALIDATE_ON_SERVER'),'N') = 'Y'
2918: then
2919: hr_dflex_utility.ins_or_upd_descflex_attribs
2920: (p_appl_short_name => 'PER'
2921: ,p_descflex_name => 'PER_PAY_PROPOSALS'
2922: ,p_attribute_category => p_rec.attribute_category
2923: ,p_attribute1_name => 'ATTRIBUTE1'
2924: ,p_attribute1_value => p_rec.attribute1
2925: ,p_attribute2_name => 'ATTRIBUTE2'

Line 3467: , per_pay_proposals pyp

3463: --
3464: cursor csr_leg_code is
3465: select pbg.legislation_code
3466: from per_business_groups pbg
3467: , per_pay_proposals pyp
3468: where pyp.pay_proposal_id = p_pay_proposal_id
3469: and pbg.business_group_id = pyp.business_group_id;
3470: --
3471: -- Declare local variables