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_SG_IRAS_AMEND_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 14: g_setup_action_id pay_payroll_actions.payroll_action_id%type;

10: g_basis_year varchar2(4);
11: g_legal_entity_id varchar2(20);
12: g_person_id per_all_people_f.person_id%type;
13: g_assignment_set_id hr_assignment_sets.assignment_set_id%type;
14: g_setup_action_id pay_payroll_actions.payroll_action_id%type;
15: g_report_type varchar2(30);
16:
17: g_previous_person_id per_all_people_f.person_id%type;
18: g_moa_369_date ff_archive_items.value%type;

Line 51: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

47: -- Action.
48: -- Core Payroll recommends the select has minimal restrictions.
49: -----------------------------------------------------------------------------
50: procedure range_code
51: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
52: p_sql out nocopy varchar2 )
53: is
54: begin
55: if g_debug then

Line 61: 'pay_payroll_actions ppa ' ||

57: end if;
58: --
59: p_sql := 'select distinct person_id ' ||
60: 'from per_people_f ppf, ' ||
61: 'pay_payroll_actions ppa ' ||
62: 'where ppa.payroll_action_id = :payroll_action_id ' ||
63: 'and ppa.business_group_id = ppf.business_group_id ' ||
64: 'order by ppf.person_id';
65: --

Line 75: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

71: -- Bug 3435334 - Pre-processor process now introduced for this archive.
72: -- Assignment actions are created for all assignments processed by pre-processor
73: ----------------------------------------------------------------------------
74: procedure assignment_action_code
75: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
76: p_start_person_id in per_all_people_f.person_id%type,
77: p_end_person_id in per_all_people_f.person_id%type,
78: p_chunk in number )
79: is

Line 81: v_setup_action_id pay_payroll_actions.payroll_action_id%type;

77: p_end_person_id in per_all_people_f.person_id%type,
78: p_chunk in number )
79: is
80: v_next_action_id pay_assignment_actions.assignment_action_id%type;
81: v_setup_action_id pay_payroll_actions.payroll_action_id%type;
82: v_assignment_id per_all_assignments_f.assignment_id%type;
83: v_person_id per_all_people_f.person_id%type;
84: v_assignment_set_id hr_assignment_sets.assignment_set_id%type;
85: --

Line 86: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is

82: v_assignment_id per_all_assignments_f.assignment_id%type;
83: v_person_id per_all_people_f.person_id%type;
84: v_assignment_set_id hr_assignment_sets.assignment_set_id%type;
85: --
86: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
87: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)
88: ,pay_core_utils.get_parameter('PERSON_ID',legislative_parameters)
89: ,pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters)
90: from pay_payroll_actions

Line 90: from pay_payroll_actions

86: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
87: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)
88: ,pay_core_utils.get_parameter('PERSON_ID',legislative_parameters)
89: ,pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters)
90: from pay_payroll_actions
91: where payroll_action_id = c_payroll_Action_id;
92: --
93: cursor next_action_id is
94: select pay_assignment_actions_s.nextval

Line 98: (c_setup_action_id in pay_payroll_actions.payroll_action_id%type,

94: select pay_assignment_actions_s.nextval
95: from dual;
96: --
97: cursor process_assignments
98: (c_setup_action_id in pay_payroll_actions.payroll_action_id%type,
99: c_person_id in per_all_people_f.person_id%type,
100: c_assignment_set_id in hr_assignment_sets.assignment_set_id%type) is
101: select distinct pai.assignment_id
102: from pay_action_information pai

Line 119: from pay_payroll_actions ppa,

115:
116: cursor csr_archive_action_id(p_assignment_id NUMBER)
117: is
118: select paa.assignment_action_id -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
119: from pay_payroll_actions ppa,
120: pay_assignment_actions paa
121: where ppa.payroll_action_id in (
122: SELECT org_information2
123: FROM hr_organization_information

Line 138: pay_payroll_actions mpl

134: and exists
135: ( select null
136: from per_assignments_f paf,
137: pay_assignment_actions mcl,
138: pay_payroll_actions mpl
139: where paf.assignment_id = mcl.assignment_id
140: and mpl.payroll_action_id = mcl.payroll_action_id
141: and mcl.assignment_Action_id = intl.locking_action_id
142: and mpl.effective_date between g_basis_start and g_basis_end

Line 217: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )

213: -- Bug 3435334 - Pre-processor process now introduced for this archive.
214: -- Populating PL/SQL table logic with rehire query is removed
215: ------------------------------------------------------------------------
216: procedure initialization_code
217: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
218: is
219: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) is
220: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
221: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),

Line 219: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) is

215: ------------------------------------------------------------------------
216: procedure initialization_code
217: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
218: is
219: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) is
220: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
221: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
222: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
223: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),

Line 227: from pay_payroll_actions

223: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
224: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
225: pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters),
226: report_type
227: from pay_payroll_actions
228: where payroll_action_id = c_payroll_action_id;
229: ------------------------------------------------------------------------
230: -- Bug 3933332 - Get A8A_Applicable flag
231: ------------------------------------------------------------------------

Line 236: pay_payroll_actions

232: cursor get_org_a8a_applicable
233: is
234: select org_information19
235: from hr_organization_information,
236: pay_payroll_actions
237: where org_information_context ='SG_LEGAL_ENTITY'
238: and organization_id = pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters)
239: and payroll_action_id = p_payroll_action_id;
240: begin

Line 283: v_archive_date pay_payroll_actions.effective_date%type;

279: is
280: v_person_id per_all_people_f.person_id%type;
281: v_assignment_id per_all_assignments_f.assignment_id%type;
282: v_national_identifier varchar2(50);
283: v_archive_date pay_payroll_actions.effective_date%type;
284: l_person_id per_all_people_f.person_id%type;
285: l_archived_person_id binary_integer;
286:
287: ------------------------------------------------------------------------

Line 981: pay_payroll_actions ppamax

977: max(pacmax.action_sequence) act_seq,
978: to_char(ppamax.effective_date,'MM')
979: from per_assignments_f paamax,
980: pay_assignment_actions pacmax,
981: pay_payroll_actions ppamax
982: where ppamax.business_group_id = c_business_group_id
983: and pacmax.tax_unit_id = c_legal_entity_id
984: and paamax.person_id = c_person_id
985: and paamax.assignment_id = pacmax.assignment_id

Line 1008: pay_payroll_actions ppa

1004: decode(ppa.action_type,'V',fnd_date.date_to_canonical(ppa.effective_date),fnd_date.date_to_canonical(ppa.date_earned)) date_earned,
1005: pac.tax_unit_id tax_uid
1006: from per_assignments_f paa,
1007: pay_assignment_actions pac,
1008: pay_payroll_actions ppa
1009: where ppa.business_group_id = c_business_group_id
1010: and pac.tax_unit_id = c_legal_entity_id
1011: and paa.person_id = c_person_id
1012: and paa.assignment_id = pac.assignment_id

Line 1556: from pay_payroll_actions ppa,

1552: INTO l_temp_value
1553: FROM ff_archive_items arch
1554: WHERE arch.user_entity_id = t_user_entity_id(i)
1555: AND arch.context1 IN( select paa.assignment_action_id -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
1556: from pay_payroll_actions ppa,
1557: pay_assignment_actions paa
1558: where ppa.payroll_action_id in (SELECT org_information2
1559: FROM hr_organization_information
1560: WHERE org_information_context = 'SG_IRAS_DETAILS'

Line 1660: from pay_payroll_actions ppa,

1656: into l_temp_value
1657: from ff_archive_items arch
1658: where arch.user_entity_id = t_user_entity_id_ir8a(counter)
1659: and arch.context1 IN( select paa.assignment_action_id -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
1660: from pay_payroll_actions ppa,
1661: pay_assignment_actions paa
1662: where ppa.payroll_action_id in (SELECT org_information2
1663: FROM hr_organization_information
1664: WHERE org_information_context = 'SG_IRAS_DETAILS'

Line 1717: from pay_payroll_actions ppa,

1713: into l_temp_value
1714: from ff_archive_items arch
1715: where arch.user_entity_id = t_user_entity_id_ir8s(counter)
1716: and arch.context1 IN( select paa.assignment_action_id -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
1717: from pay_payroll_actions ppa,
1718: pay_assignment_actions paa
1719: where ppa.payroll_action_id in (SELECT org_information2
1720: FROM hr_organization_information
1721: WHERE org_information_context = 'SG_IRAS_DETAILS'

Line 1790: from pay_payroll_actions ppa,

1786: from ff_archive_items arch
1787: where arch.user_entity_id = t_user_entity_id_a8a(i)
1788: and arch.context1 IN( select paa.assignment_action_id
1789: -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
1790: from pay_payroll_actions ppa,
1791: pay_assignment_actions paa
1792: where ppa.payroll_action_id in (SELECT org_information2
1793: FROM hr_organization_information
1794: WHERE org_information_context = 'SG_IRAS_DETAILS'

Line 2139: from pay_payroll_actions ppa,

2135: 'X_ADDITIONAL_EARNINGS_DATE')
2136: and ue.user_entity_id = arch.user_entity_id
2137: AND ARCH.CONTEXT1 in ( select paa.assignment_action_id
2138: -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
2139: from pay_payroll_actions ppa,
2140: pay_assignment_actions paa
2141: where ppa.payroll_action_id in (SELECT org_information2
2142: FROM hr_organization_information
2143: WHERE org_information_context = 'SG_IRAS_DETAILS'

Line 2352: from pay_payroll_actions ppa,

2348: ff_archive_item_contexts con2
2349: where arch.user_entity_id = c_user_entity_id
2350: and arch.context1 IN(
2351: select paa.assignment_action_id -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
2352: from pay_payroll_actions ppa,
2353: pay_assignment_actions paa
2354: where ppa.payroll_action_id in (
2355: SELECT org_information2
2356: FROM hr_organization_information

Line 2416: from pay_payroll_actions ppa,

2412: where ue.user_entity_name = 'X_SG_LEGAL_ENTITY_SG_A8B_INCORP_DATE'
2413: and ue.user_entity_id = arch.user_entity_id
2414: AND ARCH.CONTEXT1 in ( select paa.assignment_action_id
2415: -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
2416: from pay_payroll_actions ppa,
2417: pay_assignment_actions paa
2418: where ppa.payroll_action_id in (
2419: SELECT org_information2
2420: FROM hr_organization_information

Line 2464: from pay_payroll_actions ppa,

2460: from ff_archive_items arch
2461: where arch.user_entity_id = t_user_entity_id_a8b(1)
2462: and arch.context1 IN(
2463: select paa.assignment_action_id -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
2464: from pay_payroll_actions ppa,
2465: pay_assignment_actions paa
2466: where ppa.payroll_action_id in (
2467: SELECT org_information2
2468: FROM hr_organization_information

Line 2510: from pay_payroll_actions ppa,

2506: ,'X_A8B_GRANT_TYPE')
2507: and ue.user_entity_id = arch.user_entity_id
2508: AND ARCH.CONTEXT1 in ( select paa.assignment_action_id
2509: -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
2510: from pay_payroll_actions ppa,
2511: pay_assignment_actions paa
2512: where ppa.payroll_action_id in (SELECT org_information2
2513: FROM hr_organization_information
2514: WHERE org_information_context = 'SG_IRAS_DETAILS'

Line 2564: from pay_payroll_actions ppa,

2560: from ff_archive_items arch
2561: where arch.user_entity_id = t_user_entity_id_a8b(1)
2562: and arch.context1 IN(
2563: select paa.assignment_action_id -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
2564: from pay_payroll_actions ppa,
2565: pay_assignment_actions paa
2566: where ppa.payroll_action_id in (
2567: SELECT org_information2
2568: FROM hr_organization_information

Line 2932: from pay_payroll_actions ppa,

2928: ff_archive_item_contexts con2
2929: where arch.user_entity_id = c_user_entity_id
2930: and arch.context1 IN(
2931: select paa.assignment_action_id -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
2932: from pay_payroll_actions ppa,
2933: pay_assignment_actions paa
2934: where ppa.payroll_action_id in (
2935: SELECT org_information2
2936: FROM hr_organization_information

Line 3001: from pay_payroll_actions ppa,

2997: from ff_archive_items arch
2998: where arch.user_entity_id = t_user_entity_id_ir8s_c(counter)
2999: and arch.context1 IN(
3000: select paa.assignment_action_id -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
3001: from pay_payroll_actions ppa,
3002: pay_assignment_actions paa
3003: where ppa.payroll_action_id in (
3004: SELECT org_information2
3005: FROM hr_organization_information

Line 3057: from pay_payroll_actions ppa,

3053: ,'X_DTM506')
3054: and ue.user_entity_id = arch.user_entity_id
3055: AND ARCH.CONTEXT1 in ( select paa.assignment_action_id
3056: -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
3057: from pay_payroll_actions ppa,
3058: pay_assignment_actions paa
3059: where ppa.payroll_action_id in (SELECT org_information2
3060: FROM hr_organization_information
3061: WHERE org_information_context = 'SG_IRAS_DETAILS'

Line 3135: from pay_payroll_actions ppa,

3131: from ff_archive_items arch
3132: where arch.user_entity_id = t_user_entity_id_ir8s_c(counter)
3133: and arch.context1 IN(
3134: select paa.assignment_action_id -- ALL PREV ORIGINAL AND AMENDMENT ARCHIVES SUBMITTED B4
3135: from pay_payroll_actions ppa,
3136: pay_assignment_actions paa
3137: where ppa.payroll_action_id in (
3138: SELECT org_information2
3139: FROM hr_organization_information

Line 3394: procedure deinit_code ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )

3390: -- Bug 3118540 -
3391: -- Bug 3435334 - This function removes setup action when ran for IRAS Line Archive /
3392: -- initiates SRS 'IR8S Ad Hoc Printed Archive' when ran for IR8S adhoc archive
3393: --------------------------------------------------------------------------------
3394: procedure deinit_code ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
3395: is
3396: l_report_type varchar2(30);
3397: l_rep_req_id number;
3398: v_setup_action pay_payroll_actions.payroll_action_id%type;

Line 3398: v_setup_action pay_payroll_actions.payroll_action_id%type;

3394: procedure deinit_code ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
3395: is
3396: l_report_type varchar2(30);
3397: l_rep_req_id number;
3398: v_setup_action pay_payroll_actions.payroll_action_id%type;
3399: begin
3400: l_rep_req_id := 0;
3401: v_setup_action := 0;
3402: if g_debug then

Line 3408: from pay_payroll_actions ppa

3404: end if;
3405: --
3406: select report_type
3407: into l_report_type
3408: from pay_payroll_actions ppa
3409: where ppa.payroll_action_id = p_payroll_action_id ;
3410: --
3411: if l_report_type = 'SG_IRAS_AMEND_ARCHIVE' then
3412: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)

Line 3414: from pay_payroll_actions

3410: --
3411: if l_report_type = 'SG_IRAS_AMEND_ARCHIVE' then
3412: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)
3413: into v_setup_action
3414: from pay_payroll_actions
3415: where payroll_action_id = p_payroll_action_id ;
3416: --------------------------------------------------------
3417: -- Bug: 3910804 Delete data from pay_action_information
3418: -------------------------------------------------------

Line 3442: p_setup_action_id in pay_payroll_actions.payroll_action_id%type,

3438: -- For second case it also populates global table with all its previous employement records
3439: ----------------------------------------------------------------------
3440: function employee_if_latest ( p_national_identifier in varchar2,
3441: p_person_id in per_all_people_f.person_id%type,
3442: p_setup_action_id in pay_payroll_actions.payroll_action_id%type,
3443: p_report_type in varchar2 ) return boolean
3444: is
3445: type t_person_start_date_tab is table of per_all_people_f.start_date%type;
3446: g_person_start_date_tab t_person_start_date_tab;