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_PPC_BUS dependencies on PER_PAY_PROPOSALS

Line 116: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE

112: -- Access Status
113: -- Internal Table Handler Use Only.
114: --
115: procedure chk_access
116: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
117: ) is
118: --
119: -- Declare local variables
120: --

Line 128: from per_pay_proposals pyp,

124: -- Cursor to check access to the assignment record
125: --
126: cursor csr_asg_sec is
127: select null
128: from per_pay_proposals pyp,
129: per_assignments_f2 asg
130: where pyp.pay_proposal_id = p_pay_proposal_id
131: and pyp.assignment_id = asg.assignment_id
132: and pyp.change_date between asg.effective_start_date

Line 159: -- - Validates that the pay_proposal_id exists in per_pay_proposals

155: -------------------------------------------------------------------------------
156: --
157: --
158: -- Description:
159: -- - Validates that the pay_proposal_id exists in per_pay_proposals
160: -- - Checks that the pay_proposal_id is not null
161: -- if p_validate is not 'WEAK' then it also
162: -- - Validates that the multiple_components flag in per_pay_proposals
163: -- is not set to 'N'

Line 162: -- - Validates that the multiple_components flag in per_pay_proposals

158: -- Description:
159: -- - Validates that the pay_proposal_id exists in per_pay_proposals
160: -- - Checks that the pay_proposal_id is not null
161: -- if p_validate is not 'WEAK' then it also
162: -- - Validates that the multiple_components flag in per_pay_proposals
163: -- is not set to 'N'
164: -- - Validates that the approved flag in per_pay_proposals table is not
165: -- set to 'Y'.
166: --

Line 164: -- - Validates that the approved flag in per_pay_proposals table is not

160: -- - Checks that the pay_proposal_id is not null
161: -- if p_validate is not 'WEAK' then it also
162: -- - Validates that the multiple_components flag in per_pay_proposals
163: -- is not set to 'N'
164: -- - Validates that the approved flag in per_pay_proposals table is not
165: -- set to 'Y'.
166: --
167: -- Pre_conditions:
168: -- A valid business_group_id

Line 208: l_approved per_pay_proposals.approved%TYPE;

204: --
205: l_proc varchar2(72) := g_package||'chk_pay_proposal_id';
206: l_exists varchar2(1);
207: l_api_updating boolean;
208: l_approved per_pay_proposals.approved%TYPE;
209: l_multiple_components per_pay_proposals.multiple_components%TYPE;
210: l_business_group_id per_pay_proposals.business_group_id%TYPE;
211: --
212: --

Line 209: l_multiple_components per_pay_proposals.multiple_components%TYPE;

205: l_proc varchar2(72) := g_package||'chk_pay_proposal_id';
206: l_exists varchar2(1);
207: l_api_updating boolean;
208: l_approved per_pay_proposals.approved%TYPE;
209: l_multiple_components per_pay_proposals.multiple_components%TYPE;
210: l_business_group_id per_pay_proposals.business_group_id%TYPE;
211: --
212: --
213: -- Cursor to check for valid pay_proposal_id and gets the value

Line 210: l_business_group_id per_pay_proposals.business_group_id%TYPE;

206: l_exists varchar2(1);
207: l_api_updating boolean;
208: l_approved per_pay_proposals.approved%TYPE;
209: l_multiple_components per_pay_proposals.multiple_components%TYPE;
210: l_business_group_id per_pay_proposals.business_group_id%TYPE;
211: --
212: --
213: -- Cursor to check for valid pay_proposal_id and gets the value
214: -- of the approved and multiple_components flag

Line 218: from per_pay_proposals pro

214: -- of the approved and multiple_components flag
215: --
216: cursor csr_pay_proposal_details is
217: select pro.approved, pro.multiple_components,pro.business_group_id
218: from per_pay_proposals pro
219: where pro.pay_proposal_id = p_pay_proposal_id;
220: --
221: --
222: begin

Line 468: from per_pay_proposals

464: -- this date is used in the lookup (i.e. New standard).
465: --
466: cursor csr_get_date is
467: select change_date, approved
468: from per_pay_proposals
469: where pay_proposal_id = p_pay_proposal_id;
470: --
471: begin
472: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 642: l_date per_pay_proposals.change_date%TYPE;

638: l_change_amount_n
639: per_pay_proposal_components.change_amount_n%TYPE;
640: l_change_percentage
641: per_pay_proposal_components.change_percentage%TYPE;
642: l_date per_pay_proposals.change_date%TYPE;
643: l_assignment_id number;
644: l_business_group_id number;
645: l_change_date date;
646: l_prev_date date;

Line 660: -- from per_pay_proposals pro

656: -- appropriate index to be used instead of a full table scan.
657: --
658: -- CURSOR csr_last_proposed_salary is
659: -- select pro.proposed_salary_n
660: -- from per_pay_proposals pro
661: -- where pro.change_date=(select max(pro2.change_date)
662: -- from per_pay_proposals pro2
663: -- where pro2.assignment_id=pro.assignment_id
664: -- and pro2.approved='Y'

Line 662: -- from per_pay_proposals pro2

658: -- CURSOR csr_last_proposed_salary is
659: -- select pro.proposed_salary_n
660: -- from per_pay_proposals pro
661: -- where pro.change_date=(select max(pro2.change_date)
662: -- from per_pay_proposals pro2
663: -- where pro2.assignment_id=pro.assignment_id
664: -- and pro2.approved='Y'
665: -- and pro2.pay_proposal_id<>p_pay_proposal_id)
666: -- and pro.assignment_id = (select pro3.assignment_id

Line 667: -- from per_pay_proposals pro3

663: -- where pro2.assignment_id=pro.assignment_id
664: -- and pro2.approved='Y'
665: -- and pro2.pay_proposal_id<>p_pay_proposal_id)
666: -- and pro.assignment_id = (select pro3.assignment_id
667: -- from per_pay_proposals pro3
668: -- where pro3.pay_proposal_id=p_pay_proposal_id);
669: --
670: CURSOR csr_dates(p_pay_proposal_id number) is
671: select pro2.assignment_id, pro2.business_group_id,

Line 673: from per_pay_proposals pro2

669: --
670: CURSOR csr_dates(p_pay_proposal_id number) is
671: select pro2.assignment_id, pro2.business_group_id,
672: pro2.change_date, pro2.change_date-1 prev_date
673: from per_pay_proposals pro2
674: where pro2.pay_proposal_id = p_pay_proposal_id;
675:
676: CURSOR csr_proposal_info(p_assignment_id number, p_query_date date)
677: is

Line 685: from per_pay_proposals ppp

681: (ppp.assignment_id, change_date, ppb.pay_annualization_factor,
682: ppb.pay_basis)) annualization_factor,
683: pet.input_currency_code as currency_code, ppb.pay_basis
684: frequency
685: from per_pay_proposals ppp
686: ,per_all_assignments_f paa
687: ,per_pay_bases ppb
688: ,pay_input_values_f piv
689: ,pay_element_types_f pet

Line 707: from per_pay_proposals p1,

703: between pet.effective_start_date and pet.effective_end_date;
704:
705: CURSOR csr_last_proposed_salary is
706: select p1.proposed_salary_n
707: from per_pay_proposals p1,
708: (select pro2.assignment_id, pro2.change_date-1 prev_date
709: from per_pay_proposals pro2
710: where pro2.pay_proposal_id = p_pay_proposal_id ) p2
711: where p1.date_to = prev_date

Line 709: from per_pay_proposals pro2

705: CURSOR csr_last_proposed_salary is
706: select p1.proposed_salary_n
707: from per_pay_proposals p1,
708: (select pro2.assignment_id, pro2.change_date-1 prev_date
709: from per_pay_proposals pro2
710: where pro2.pay_proposal_id = p_pay_proposal_id ) p2
711: where p1.date_to = prev_date
712: and p1.assignment_id = p2.assignment_id;
713:

Line 890: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

886: ) is
887: --
888: l_exists varchar2(1);
889: l_proc varchar2(72):= g_package || 'chk_delete_component';
890: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
891: --
892: -- Cursor to check the status of the per_pay-proposal apprved flag.
893: --
894: cursor csr_proposal_status is

Line 896: from per_pay_proposals pro

892: -- Cursor to check the status of the per_pay-proposal apprved flag.
893: --
894: cursor csr_proposal_status is
895: select null
896: from per_pay_proposals pro
897: where pro.pay_proposal_id = l_pay_proposal_id
898: and pro.approved = 'Y';
899: --
900: -- Cursor to check that this component exists for this proposal