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.PAY_IE_P45_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1720: CURSOR Cur_Act_Contexts_ppsn(l_defined_bal_id number,c_ppsn_override per_assignment_extra_info.aei_information1%type) IS

1716: AND pai.action_information_category = 'EMEA BALANCES'
1717: AND pai.action_information1 = p_defined_bal_id;
1718:
1719: /* 7291676 */
1720: CURSOR Cur_Act_Contexts_ppsn(l_defined_bal_id number,c_ppsn_override per_assignment_extra_info.aei_information1%type) IS
1721: SELECT sum(PAY_BALANCE_PKG.GET_VALUE(l_defined_bal_id, -- changes made
1722: pac.ASSIGNMENT_ACTION_ID,
1723: g_paye_ref,
1724: null,

Line 1734: from per_all_assignments_f paaf, per_assignment_extra_info paei

1730: pay_assignment_actions pas,
1731: pay_payroll_actions ppa
1732: WHERE pac.Context_Value like 'IE_A%'
1733: AND pac.assignment_id in (select paaf.assignment_id
1734: from per_all_assignments_f paaf, per_assignment_extra_info paei
1735: where paaf.person_id = p_person_id
1736: and paaf.assignment_id=paei.assignment_id
1737: and paei.information_type = 'IE_ASG_OVERRIDE'
1738: and paei.aei_information1 = c_ppsn_override

Line 1752: from per_assignment_extra_info

1748:
1749: cursor csr_ppsn_override(p_asg_id number)
1750: is
1751: select aei_information1 PPSN_OVERRIDE
1752: from per_assignment_extra_info
1753: where assignment_id = p_asg_id
1754: and aei_information_category = 'IE_ASG_OVERRIDE';
1755:
1756: l_ppsn_override per_assignment_extra_info.aei_information1%type;

Line 1756: l_ppsn_override per_assignment_extra_info.aei_information1%type;

1752: from per_assignment_extra_info
1753: where assignment_id = p_asg_id
1754: and aei_information_category = 'IE_ASG_OVERRIDE';
1755:
1756: l_ppsn_override per_assignment_extra_info.aei_information1%type;
1757:
1758: v_Cur_Act_Contexts Cur_Act_Contexts%ROWTYPE;
1759: --Bug 3079945 End
1760: l_action_info_id NUMBER;

Line 3762: from per_assignment_extra_info

3758:
3759: cursor csr_ppsn_override(p_asg_id number)
3760: is
3761: select aei_information1 PPSN_OVERRIDE
3762: from per_assignment_extra_info
3763: where assignment_id = p_asg_id
3764: and aei_information_category = 'IE_ASG_OVERRIDE';
3765:
3766: l_ppsn_override per_assignment_extra_info.aei_information1%type;

Line 3766: l_ppsn_override per_assignment_extra_info.aei_information1%type;

3762: from per_assignment_extra_info
3763: where assignment_id = p_asg_id
3764: and aei_information_category = 'IE_ASG_OVERRIDE';
3765:
3766: l_ppsn_override per_assignment_extra_info.aei_information1%type;
3767:
3768: cursor csr_ppsn_min_asg(p_ppsn_override varchar2, p_person_id number)
3769: is
3770: select MIN(paei.assignment_id) ovrride_asg

Line 3771: from per_assignment_extra_info paei

3767:
3768: cursor csr_ppsn_min_asg(p_ppsn_override varchar2, p_person_id number)
3769: is
3770: select MIN(paei.assignment_id) ovrride_asg
3771: from per_assignment_extra_info paei
3772: where paei.information_type = 'IE_ASG_OVERRIDE'
3773: and paei.aei_information1 = p_ppsn_override
3774: and exists
3775: (select 1 from per_all_assignments_f paaf

Line 3780: l_ppsn_override_asg per_assignment_extra_info.assignment_id%type;

3776: where paaf.assignment_id = paei.assignment_id
3777: and paaf.person_id = p_person_id)
3778: GROUP BY paei.aei_information1;
3779:
3780: l_ppsn_override_asg per_assignment_extra_info.assignment_id%type;
3781: l_temp_person_id per_people_f.person_id%TYPE :=0;
3782:
3783:
3784: l_actid NUMBER;

Line 4059: from per_assignment_extra_info

4055:
4056: cursor csr_ppsn_override(p_asg_id number)
4057: is
4058: select aei_information1 PPSN_OVERRIDE
4059: from per_assignment_extra_info
4060: where assignment_id = p_asg_id
4061: and aei_information_category = 'IE_ASG_OVERRIDE';
4062:
4063: l_ppsn_override per_assignment_extra_info.aei_information1%type;

Line 4063: l_ppsn_override per_assignment_extra_info.aei_information1%type;

4059: from per_assignment_extra_info
4060: where assignment_id = p_asg_id
4061: and aei_information_category = 'IE_ASG_OVERRIDE';
4062:
4063: l_ppsn_override per_assignment_extra_info.aei_information1%type;
4064:
4065: CURSOR cur_child_pay_action_ppsn (p_person_id IN NUMBER,
4066: p_effective_date IN DATE,
4067: p_lat_act_seq IN NUMBER,

Line 4068: c_ppsn_override per_assignment_extra_info.aei_information1%type) is

4064:
4065: CURSOR cur_child_pay_action_ppsn (p_person_id IN NUMBER,
4066: p_effective_date IN DATE,
4067: p_lat_act_seq IN NUMBER,
4068: c_ppsn_override per_assignment_extra_info.aei_information1%type) is
4069: SELECT /*+ USE_NL(paa, ppa) */
4070: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
4071: paa.assignment_action_id),16))
4072: FROM pay_assignment_actions paa,

Line 4076: from per_all_assignments_f paaf, per_assignment_extra_info paei

4072: FROM pay_assignment_actions paa,
4073: pay_payroll_actions ppa
4074: WHERE paa.payroll_action_id = ppa.payroll_action_id
4075: AND paa.assignment_id in (select paaf.assignment_id
4076: from per_all_assignments_f paaf, per_assignment_extra_info paei
4077: where paaf.person_id = p_person_id
4078: and paaf.assignment_id=paei.assignment_id
4079: and paei.information_type = 'IE_ASG_OVERRIDE'
4080: and paei.aei_information1 = c_ppsn_override --'314678745T'

Line 4485: FROM per_assignment_extra_info paei,

4481:
4482: /* 7291676 */
4483: CURSOR csr_check_override_present (p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
4484: SELECT paei.aei_information1
4485: FROM per_assignment_extra_info paei,
4486: pay_assignment_actions paa
4487: WHERE paa.assignment_action_id=p_assignment_action_id
4488: and paei.assignment_id=paa.assignment_id
4489: and paei.aei_information_category = 'IE_ASG_OVERRIDE';

Line 4491: l_ppsn_override per_assignment_extra_info.aei_information1%type;

4487: WHERE paa.assignment_action_id=p_assignment_action_id
4488: and paei.assignment_id=paa.assignment_id
4489: and paei.aei_information_category = 'IE_ASG_OVERRIDE';
4490:
4491: l_ppsn_override per_assignment_extra_info.aei_information1%type;
4492: l_ppsn_override_flag varchar2(2);
4493:
4494: l_bal_value number:=null;
4495: l_def_bal_id pay_action_information.action_information1%TYPE := NULL;

Line 4803: from per_assignment_extra_info

4799:
4800: cursor csr_ppsn_override(p_asg_id number)
4801: is
4802: select aei_information1 PPSN_OVERRIDE
4803: from per_assignment_extra_info
4804: where assignment_id = p_asg_id
4805: and aei_information_category = 'IE_ASG_OVERRIDE';
4806:
4807: l_ppsn_override per_assignment_extra_info.aei_information1%type;

Line 4807: l_ppsn_override per_assignment_extra_info.aei_information1%type;

4803: from per_assignment_extra_info
4804: where assignment_id = p_asg_id
4805: and aei_information_category = 'IE_ASG_OVERRIDE';
4806:
4807: l_ppsn_override per_assignment_extra_info.aei_information1%type;
4808:
4809: cursor csr_supp_paydetails(p_asg_id number)
4810: is
4811: select aei_information1 year1

Line 4822: from per_assignment_extra_info

4818: ,(round(to_number(nvl(aei_information8,'0')),2)*100) pay4
4819: ,aei_information9 year5
4820: ,(round(to_number(nvl(aei_information10,'0')),2)*100) pay5
4821: ,(round(to_number(nvl(aei_information11,'0')),2)*100) allotherpay
4822: from per_assignment_extra_info
4823: where assignment_id = p_asg_id
4824: and aei_information_category = 'IE_SUPP_P45_PAY';
4825:
4826: csr_supp_paydetails_rec csr_supp_paydetails%rowtype;