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_NO_EOY_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 142: -- FROM pay_assignment_actions paa

138: -- ,p_reporting_code IN VARCHAR2) IS
139: -- SELECT asg_act.action_information5 person_id
140: -- ,asg_act.action_information6 tax_municipality
141: -- ,TO_NUMBER(rep_cde.action_information3) amount
142: -- FROM pay_assignment_actions paa
143: -- ,pay_action_information asg_act
144: -- ,pay_action_information rep_cde
145: -- WHERE paa.payroll_action_id = p_payroll_action_id
146: -- AND asg_act.action_context_type = 'AAP'

Line 1100: FROM pay_assignment_actions paa

1096: hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ZONE'))) ni_zone
1097: -- ,TO_NUMBER(SUBSTR(lu.meaning, 1,1)) ni_zone
1098: ,DECODE(orginf2.org_information5,'Y', orginf2.org_information2,orginf1.org_information4) nace_code -- 2007/08 changes
1099: ,paa.assignment_id assg_id -- 2007/2008 Changes
1100: FROM pay_assignment_actions paa
1101: ,pay_payroll_actions ppa
1102: ,pay_action_contexts pac1
1103: ,pay_action_contexts pac2
1104: ,ff_contexts ctx1

Line 1144: ,pay_assignment_actions paa

1140: ,p_legal_employer_id IN NUMBER
1141: ,p_assg_id IN NUMBER) IS
1142: SELECT max(paa.assignment_action_id)
1143: FROM pay_payroll_actions ppa
1144: ,pay_assignment_actions paa
1145: WHERE ppa.business_group_id = p_business_group_id
1146: AND ppa.action_type IN ('R','Q','I','B')
1147: AND ppa.action_status = 'C'
1148: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1633: ,pay_assignment_actions paa

1629: ,MAX(ppa.effective_date) effective_date
1630: ,MAX(asg.effective_end_date) effective_end_date
1631: ,MAX(asg.effective_start_date) effective_start_date --Changes 2007/2008
1632: FROM per_all_assignments_f asg
1633: ,pay_assignment_actions paa
1634: ,pay_payroll_actions ppa
1635: ,pay_action_information ai
1636: ,pay_action_contexts ac1
1637: ,ff_contexts ctx1

Line 1812: SELECT pay_assignment_actions_s.nextval INTO l_assact_id FROM dual;

1808: --
1809: --
1810: -- Create assignment action for archive process.
1811: --
1812: SELECT pay_assignment_actions_s.nextval INTO l_assact_id FROM dual;
1813: hr_nonrun_asact.insact
1814: (l_assact_id
1815: ,l_asg_rec.assignment_id
1816: ,p_payroll_action_id

Line 1875: ,pay_assignment_actions paa

1871: ,asg_act.action_information4 ni_zone
1872: ,asg_act.action_information6 tax_municipality_id
1873: ,asg_act.action_information8 municipality_code
1874: FROM pay_action_information asg_act
1875: ,pay_assignment_actions paa
1876: WHERE asg_act.action_information_category = 'EMEA REPORT INFORMATION'
1877: AND asg_act.action_information1 = 'ASG_ACT_INFO'
1878: AND asg_act.action_context_type = 'AAP'
1879: AND asg_act.action_context_id = paa.assignment_action_id

Line 1928: ,pay_assignment_actions paa

1924: -- ,pivf.uom dtype
1925: FROM pay_action_information cde_dtl
1926: ,pay_action_information cde_info_dtl
1927: ,pay_element_type_extra_info eei
1928: ,pay_assignment_actions paa
1929: ,pay_action_contexts ac1
1930: ,ff_contexts ctx1
1931: ,pay_action_contexts ac2
1932: ,ff_contexts ctx2

Line 2044: FROM pay_assignment_actions paa

2040: ,p_report_date IN DATE
2041: ,l_element_name IN VARCHAR2 ) IS
2042: SELECT rrv.result_value value
2043: ,pivf.uom dtype
2044: FROM pay_assignment_actions paa
2045: ,pay_action_contexts ac1
2046: ,ff_contexts ctx1
2047: ,pay_action_contexts ac2
2048: ,ff_contexts ctx2

Line 2105: FROM pay_assignment_actions paa

2101: ,petf.element_type_id element_type_id
2102: ,rr.run_result_id rr_id
2103: ,petf.element_name element_name
2104: ,ppa.action_type action_type
2105: FROM pay_assignment_actions paa
2106: ,pay_action_contexts ac1
2107: ,ff_contexts ctx1
2108: ,pay_action_contexts ac2
2109: ,ff_contexts ctx2

Line 2750: FROM pay_assignment_actions paa

2746: CURSOR csr_LE_PER_BELOW_REP_LIMIT
2747: (p_payroll_action_id IN NUMBER) IS
2748: SELECT le_lu.action_information2 legal_employer_id
2749: ,asg_act.action_information5 person_id
2750: FROM pay_assignment_actions paa
2751: ,pay_action_information le_lu
2752: ,pay_action_information asg_act
2753: ,pay_action_information rep_cde
2754: ,pay_action_information cde_dtl

Line 2789: ,pay_assignment_actions paa

2785: SELECT asg_act.action_information_id
2786: ,asg_act.object_version_number
2787: ,paa.assignment_id
2788: FROM pay_action_information asg_act
2789: ,pay_assignment_actions paa
2790: WHERE asg_act.action_information_category = 'EMEA REPORT INFORMATION'
2791: AND asg_act.action_information1 = 'ASG_ACT_INFO'
2792: AND asg_act.action_information2 = p_legal_employer_id
2793: AND asg_act.action_information5 = p_person_id

Line 2818: FROM pay_assignment_actions paa

2814: ,rep_cde.action_information13 cinfo3
2815: ,rep_cde.action_information14 cinfo4
2816: ,rep_cde.action_information15 cinfo5
2817: ,rep_cde.action_information16 cinfo6
2818: FROM pay_assignment_actions paa
2819: ,pay_action_information asg_act
2820: ,pay_action_information rep_cde
2821: ,pay_action_information cde_dtl
2822: WHERE paa.payroll_action_id = p_payroll_action_id

Line 2859: FROM pay_assignment_actions paa

2855: ,rep_cde.action_information13 cinfo3
2856: ,rep_cde.action_information14 cinfo4
2857: ,rep_cde.action_information15 cinfo5
2858: ,rep_cde.action_information16 cinfo6
2859: FROM pay_assignment_actions paa
2860: ,pay_action_information asg_act
2861: ,pay_action_information rep_cde
2862: ,pay_action_information cde_dtl
2863: WHERE paa.payroll_action_id = p_payroll_action_id

Line 3634: FROM pay_assignment_actions paa

3630: ,0)) sum_zone5
3631: ,SUM(DECODE(TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3632: ,'1', fnd_number.canonical_to_number(rep_cde.action_information3)
3633: ,0)) sum_totals
3634: FROM pay_assignment_actions paa
3635: ,pay_action_information le_lu
3636: ,pay_action_information asg_act
3637: ,pay_action_information rep_cde
3638: ,pay_action_information cde_dtl

Line 3677: FROM pay_assignment_actions paa

3673: ,SUM(DECODE(asg_act.action_information7
3674: ,'Y', fnd_number.canonical_to_number(rep_cde.action_information3)
3675: , 0)) bl_earnings
3676: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) sum_earnings
3677: FROM pay_assignment_actions paa
3678: ,pay_action_information le_lu
3679: ,pay_action_information asg_act
3680: ,pay_action_information rep_cde
3681: ,pay_action_information cde_dtl

Line 3718: FROM pay_assignment_actions paa

3714: SELECT asg_act.action_information2 legal_employer_id
3715: ,le_lu.action_information3 si_status
3716: ,DECODE(cde_dtl.action_information4, 'Y', rep_cde.action_information2, 'TOTAL_OTHER_CODES') code
3717: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
3718: FROM pay_assignment_actions paa
3719: ,pay_action_information le_lu
3720: ,pay_action_information asg_act
3721: ,pay_action_information rep_cde
3722: ,pay_action_information cde_dtl

Line 4465: FROM pay_assignment_actions paa

4461: ,0)) sum_zone5
4462: ,SUM(DECODE(TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4463: ,'1', fnd_number.canonical_to_number(rep_cde.action_information3)
4464: ,0)) sum_totals
4465: FROM pay_assignment_actions paa
4466: ,pay_action_information le_lu
4467: ,pay_action_information asg_act
4468: ,pay_action_information rep_cde
4469: ,pay_action_information cde_dtl

Line 4508: FROM pay_assignment_actions paa

4504: ,SUM(DECODE(asg_act.action_information7
4505: ,'Y', fnd_number.canonical_to_number(rep_cde.action_information3)
4506: , 0)) bl_earnings
4507: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) sum_earnings
4508: FROM pay_assignment_actions paa
4509: ,pay_action_information le_lu
4510: ,pay_action_information asg_act
4511: ,pay_action_information rep_cde
4512: ,pay_action_information cde_dtl

Line 4549: FROM pay_assignment_actions paa

4545: SELECT asg_act.action_information2 legal_employer_id
4546: ,le_lu.action_information3 si_status
4547: ,DECODE(cde_dtl.action_information4, 'Y', rep_cde.action_information2, 'TOTAL_OTHER_CODES') code
4548: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
4549: FROM pay_assignment_actions paa
4550: ,pay_action_information le_lu
4551: ,pay_action_information asg_act
4552: ,pay_action_information rep_cde
4553: ,pay_action_information cde_dtl