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 PAY_PAYROLL_ACTIONS

Line 294: FROM pay_payroll_actions

290: INSTR(legislative_parameters,' ',
291: INSTR(legislative_parameters,p_token))
292: - (INSTR(legislative_parameters,p_token)+LENGTH(p_token))),
293: business_group_id
294: FROM pay_payroll_actions
295: WHERE payroll_action_id = p_pact_id;
296:
297: l_business_group_id VARCHAR2(20);
298: l_token_value VARCHAR2(50);

Line 691: FROM pay_payroll_actions

687: IS
688:
689: CURSOR csr_archive_effective_date(pactid NUMBER) IS
690: SELECT effective_date
691: FROM pay_payroll_actions
692: WHERE payroll_action_id = pactid;
693:
694: CURSOR csr_input_value_id(p_element_name CHAR,
695: p_value_name CHAR) IS

Line 931: pay_payroll_actions ppa

927:
928: CURSOR cur_payroll_assg_action is
929: select paa.assignment_action_id pay_assg_act_id
930: from pay_assignment_actions paa,
931: pay_payroll_actions ppa
932: where paa.assignment_id in (select assignment_id
933: from per_all_assignments_f
934: where person_id = p_person_id
935: )

Line 967: pay_payroll_actions ppa

963:
964: CURSOR payroll_asg_action is
965: select max(paa.assignment_action_id)
966: from pay_assignment_actions paa,
967: pay_payroll_actions ppa
968: where paa.assignment_id in (select assignment_id
969: from per_all_assignments_f
970: where person_id = p_person_id
971: )

Line 1059: pay_payroll_actions ppa

1055: null,
1056: null))
1057: FROM pay_action_contexts pac,
1058: pay_assignment_actions pas,
1059: pay_payroll_actions ppa
1060: WHERE substr(pac.Context_Value,1,4) = p_context_value
1061: AND pac.assignment_id in (select papf.assignment_id
1062: from per_all_assignments_f papf
1063: where papf.person_id = p_person_id

Line 1076: pay_payroll_actions ppa,

1072:
1073: CURSOR cur_get_prev_run_seq is
1074: select paa.action_sequence
1075: from pay_assignment_actions paa,
1076: pay_payroll_actions ppa,
1077: pay_action_interlocks pai,
1078: pay_assignment_actions paa1
1079: where paa1.source_action_id = p_last_p45_act
1080: and pai.locking_action_id = paa1.assignment_action_id

Line 1547: , pay_payroll_actions PACT

1543: , pay_balance_feeds_f FEED
1544: , pay_run_results RR
1545: , pay_assignment_actions ASSACT
1546: , pay_assignment_actions BAL_ASSACT
1547: , pay_payroll_actions PACT
1548: , pay_payroll_actions BACT
1549: , per_time_periods PPTP
1550: , per_time_periods BPTP
1551: , pay_run_results PROCESS_RR

Line 1548: , pay_payroll_actions BACT

1544: , pay_run_results RR
1545: , pay_assignment_actions ASSACT
1546: , pay_assignment_actions BAL_ASSACT
1547: , pay_payroll_actions PACT
1548: , pay_payroll_actions BACT
1549: , per_time_periods PPTP
1550: , per_time_periods BPTP
1551: , pay_run_results PROCESS_RR
1552: , pay_run_result_values PROCESS

Line 1609: pay_payroll_actions ppa,pay_payroll_actions appa

1605: -- in the same tax year for which the archive is run
1606: /*CURSOR Cur_Act_Contexts IS
1607: SELECT pac.Context_ID,pac.Context_Value,pac.Assignment_action_id
1608: FROM pay_action_contexts pac,pay_assignment_actions pas,
1609: pay_payroll_actions ppa,pay_payroll_actions appa
1610: WHERE pac.Context_Value = 'IE_A'
1611: AND pac.assignment_id = p_assignment_id
1612: AND pas.assignment_action_id = pac.assignment_action_id
1613: AND ppa.payroll_action_id = pas.payroll_action_id

Line 1633: pay_payroll_actions ppa,

1629: -- the previous P45 archive.
1630: CURSOR cur_get_prev_run_seq is
1631: select paa.action_sequence
1632: from pay_assignment_actions paa,
1633: pay_payroll_actions ppa,
1634: pay_action_interlocks pai,
1635: pay_assignment_actions paa1
1636: where paa1.source_action_id = p_last_p45_action
1637: and pai.locking_action_id = paa1.assignment_action_id

Line 1668: pay_payroll_actions ppa

1664: null,
1665: null))
1666: FROM pay_action_contexts pac,
1667: pay_assignment_actions pas,
1668: pay_payroll_actions ppa
1669: WHERE pac.Context_Value like 'IE_A%'
1670: AND pac.assignment_id in (select papf.assignment_id
1671: from per_all_assignments_f papf
1672: where papf.person_id = p_person_id

Line 1731: pay_payroll_actions ppa

1727: null,
1728: null))
1729: FROM pay_action_contexts pac,
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

Line 2681: pay_payroll_actions ppa,

2677: select act_inf.action_information3
2678: from pay_assignment_actions paa_run,
2679: pay_action_interlocks pai,
2680: pay_assignment_actions paa,
2681: pay_payroll_actions ppa,
2682: pay_action_information act_inf
2683: where ppa.payroll_action_id = paa.payroll_action_id
2684: and ppa.report_type = 'P45'
2685: and ppa.report_qualifier = 'IE'

Line 2899: pay_payroll_actions ppa

2895: from pay_run_result_values prr,
2896: pay_run_results pr,
2897: pay_input_values_f piv,
2898: pay_assignment_actions pas,
2899: pay_payroll_actions ppa
2900: where pas.assignment_id in (select assignment_id
2901: from per_all_assignments_f
2902: where person_id = p_person_id)
2903: and pas.tax_unit_id = g_paye_ref

Line 2936: pay_payroll_actions ppa,

2932: select act_inf.action_information3
2933: from pay_assignment_actions paa_run,
2934: pay_action_interlocks pai,
2935: pay_assignment_actions paa,
2936: pay_payroll_actions ppa,
2937: pay_action_information act_inf
2938: where ppa.payroll_action_id = paa.payroll_action_id
2939: and ppa.report_type = 'P45'
2940: and ppa.report_qualifier = 'IE'

Line 3252: pay_payroll_actions pact,

3248: hrl.address_line_3 employer_tax_addr3,
3249: hrl.telephone_number_1 employer_tax_ref_phone
3250: --
3251: FROM pay_all_payrolls_f ppf,
3252: pay_payroll_actions pact,
3253: hr_organization_information org,
3254: hr_soft_coding_keyflex flex,
3255: hr_organization_units hou,
3256: hr_locations_all hrl

Line 3351: pay_payroll_actions pact

3347: pact.effective_date effective_date
3348: FROM pay_assignment_actions paa,
3349: pay_action_interlocks pai,
3350: pay_assignment_actions paa_arc,
3351: pay_payroll_actions pact
3352: WHERE pai.locked_action_id = paa.assignment_action_id
3353: AND pai.locking_action_id = paa_arc.assignment_action_id
3354: AND paa_arc.payroll_action_id = p_pact_id
3355: AND paa.payroll_action_id = pact.payroll_action_id

Line 3609: pay_payroll_actions ppa

3605: else
3606: */
3607: sqlstr := 'SELECT DISTINCT person_id
3608: FROM per_people_f ppf,
3609: pay_payroll_actions ppa
3610: WHERE ppa.payroll_action_id = :payroll_action_id
3611: AND ppa.business_group_id +0= ppf.business_group_id
3612: ORDER BY ppf.person_id';
3613: hr_utility.set_location('Leaving ' || l_proc,40);

Line 3642: pay_payroll_actions appa,

3638: as1.period_of_service_id period_of_service_id
3639: FROM --per_periods_of_service ppos,
3640: per_all_assignments_f as1,
3641: pay_assignment_actions act,
3642: pay_payroll_actions appa,
3643: pay_action_interlocks pai,
3644: pay_assignment_actions act1,
3645: pay_payroll_actions appa2
3646: WHERE /*appa.consolidation_set_id = p_consolidation_id*/

Line 3645: pay_payroll_actions appa2

3641: pay_assignment_actions act,
3642: pay_payroll_actions appa,
3643: pay_action_interlocks pai,
3644: pay_assignment_actions act1,
3645: pay_payroll_actions appa2
3646: WHERE /*appa.consolidation_set_id = p_consolidation_id*/
3647: act.tax_unit_id = p_paye_ref
3648: AND appa.effective_date BETWEEN g_archive_start_date AND g_archive_end_date
3649: AND as1.person_id BETWEEN stperson AND endperson

Line 3702: pay_payroll_actions appa4

3698: AND appa2.payroll_action_id = (SELECT /*+ USE_NL(ACT2 APPA4)*/
3699: max(appa4.payroll_action_id)
3700: FROM /*pay_pre_payments ppp, --Bug 4193738 --Bug 4468864*/
3701: pay_assignment_actions act2,
3702: pay_payroll_actions appa4
3703: WHERE /*ppp.assignment_action_id=act2.assignment_action_id
3704: AND*/ act2.assignment_id = act.assignment_id
3705: AND act2.action_status IN ('C','S') --10225372
3706: AND appa4.payroll_action_id = act2.payroll_action_id

Line 3713: pay_payroll_actions appa3,

3709: -- bug 5597735, change the not exists clause.
3710: -- refer bug 5233518 for more details.
3711: AND NOT EXISTS (SELECT /*+ ORDERED use_nl(appa3)*/ null
3712: from pay_assignment_actions act3,
3713: pay_payroll_actions appa3,
3714: pay_action_interlocks pai, --bug 4208273
3715: pay_assignment_actions act2, --bug 4208273
3716: pay_payroll_actions appa4 --bug 4208273
3717: where pai.locked_action_id= act3.assignment_action_id

Line 3716: pay_payroll_actions appa4 --bug 4208273

3712: from pay_assignment_actions act3,
3713: pay_payroll_actions appa3,
3714: pay_action_interlocks pai, --bug 4208273
3715: pay_assignment_actions act2, --bug 4208273
3716: pay_payroll_actions appa4 --bug 4208273
3717: where pai.locked_action_id= act3.assignment_action_id
3718: and pai.locking_action_id=act2.assignment_action_id
3719: and act3.action_sequence >= act1.action_sequence --bug 4193738
3720: and act3.assignment_id in (select distinct paaf.assignment_id

Line 3939: pay_payroll_actions paa,

3935: paa.date_earned date_earned,
3936: ptp.time_period_id time_period_id
3937: FROM pay_action_interlocks pre,
3938: pay_action_interlocks pay,
3939: pay_payroll_actions paa,
3940: pay_payroll_actions ppaa,
3941: pay_assignment_actions assact,
3942: pay_assignment_actions passact,
3943: per_time_periods ptp -- Added to retrieve correct time_period_id 4906850

Line 3940: pay_payroll_actions ppaa,

3936: ptp.time_period_id time_period_id
3937: FROM pay_action_interlocks pre,
3938: pay_action_interlocks pay,
3939: pay_payroll_actions paa,
3940: pay_payroll_actions ppaa,
3941: pay_assignment_actions assact,
3942: pay_assignment_actions passact,
3943: per_time_periods ptp -- Added to retrieve correct time_period_id 4906850
3944: WHERE pre.locked_action_id = pay.locking_action_id

Line 3964: pay_payroll_actions ppa

3960: /*CURSOR cur_child_pay_action(p_assignment_id NUMBER,
3961: p_date_earned DATE)is
3962: SELECT max(paa.assignment_action_id)
3963: FROM pay_assignment_actions paa,
3964: pay_payroll_actions ppa
3965: where paa.assignment_id = p_assignment_id
3966: AND paa.payroll_action_id = ppa.payroll_action_id
3967: AND ppa.date_earned =p_date_earned
3968: AND ppa.action_type in ('R','Q')

Line 3979: pay_payroll_actions ppa

3975: SELECT /*+ USE_NL(paa, ppa) */
3976: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
3977: paa.assignment_action_id),16))
3978: FROM pay_assignment_actions paa,
3979: pay_payroll_actions ppa
3980: WHERE paa.payroll_action_id = ppa.payroll_action_id
3981: AND paa.assignment_id in (select assignment_id
3982: from per_all_assignments_f
3983: where person_id = p_person_id

Line 3997: FROM pay_payroll_actions ppa_p45,

3993: CURSOR cur_get_latest_p45(p_pact_id NUMBER,
3994: p_person_id NUMBER
3995: ) IS
3996: SELECT max(lpad(paa_src.action_sequence,15,'0')|| paa_src.assignment_action_id)
3997: FROM pay_payroll_actions ppa_p45,
3998: pay_assignment_actions p45_src,
3999: pay_action_information pai_p45,
4000: pay_assignment_actions paa_src
4001: WHERE ppa_p45.action_type = 'X'

Line 4020: FROM pay_payroll_actions ppa,

4016: /* 7291676 */
4017: CURSOR cur_get_last_p45(p_person_id NUMBER,p_termination_date DATE,p_pact NUMBER, c_assignment_id NUMBER) IS
4018: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
4019: paa.assignment_action_id),16))
4020: FROM pay_payroll_actions ppa,
4021: pay_assignment_actions paa,
4022: pay_action_information pai
4023: WHERE paa.assignment_action_id = pai.action_context_id
4024: AND pai.action_information_category = 'IE P45 INFORMATION'

Line 4073: pay_payroll_actions ppa

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,
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

Line 4460: CURSOR csr_get_def_bal(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE

4456: AS
4457:
4458: /* Split the cursor to 2 cursors to improve the performace.new parameter is added to reduce the number of
4459: tables involved to 2 from 5 (5005788) */
4460: CURSOR csr_get_def_bal(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
4461: ,p_balance_name pay_balance_types.balance_name%TYPE
4462: ,c_ppsn_flag varchar2) IS
4463: SELECT pai1.action_information2
4464: FROM pay_action_information pai1

Line 4626: c_p45_arch_id pay_payroll_actions.payroll_action_id%TYPE) IS

4622: ORDER BY pai_iep45.action_information2;
4623: */
4624: -- The above cursor has been modified as specified below.
4625: CURSOR cur_p45_details(
4626: c_p45_arch_id pay_payroll_actions.payroll_action_id%TYPE) IS
4627: SELECT paa.assignment_id assignment_id
4628: ,paa.assignment_action_id
4629: ,pai_iep45.action_information2 supp_flag
4630: ,decode(ptp.period_type,'Lunar Month','W',decode(instr(ptp.period_type,'Week'),0,'M','W')) freq --13359530-1

Line 4755: c_p30_data_lock_process pay_payroll_actions.payroll_action_id%TYPE) IS

4751: AND emp_supp.pay_period =p_period
4752: AND emp_supp.period_frequency = decode(p_freq,'M','Monthly','Weekly');
4753: --
4754: CURSOR cur_p30_start_date(
4755: c_p30_data_lock_process pay_payroll_actions.payroll_action_id%TYPE) IS
4756: SELECT to_char(MIN(ppa_arc.start_date),'DD/MM/RRRR') start_date
4757: FROM pay_assignment_actions paa_p30,
4758: pay_action_interlocks pai_p30,
4759: pay_assignment_actions paa_arc,

Line 4760: pay_payroll_actions ppa_arc

4756: SELECT to_char(MIN(ppa_arc.start_date),'DD/MM/RRRR') start_date
4757: FROM pay_assignment_actions paa_p30,
4758: pay_action_interlocks pai_p30,
4759: pay_assignment_actions paa_arc,
4760: pay_payroll_actions ppa_arc
4761: WHERE paa_p30.payroll_Action_id = c_p30_data_lock_process
4762: AND paa_p30.assignment_action_id = pai_p30.locking_action_id
4763: AND paa_arc.assignment_action_id = pai_p30.locked_action_id
4764: AND ppa_arc.payroll_action_id = paa_arc.payroll_action_id;

Line 4767: c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE) IS

4763: AND paa_arc.assignment_action_id = pai_p30.locked_action_id
4764: AND ppa_arc.payroll_action_id = paa_arc.payroll_action_id;
4765: --
4766: CURSOR cur_employer_address(
4767: c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE) IS
4768: SELECT substr(pai.action_information5,1,30) employer_tax_addr1
4769: ,substr(pai.action_information6,1,30) employer_tax_addr2
4770: ,substr(pai.action_information7,1,30) employer_tax_addr3
4771: ,substr(pai.action_information26,1,30) employer_tax_contact