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

Line 60: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,

56: --------------------------------------------------------------------
57: */
58:
59: PROCEDURE range_code
60: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
61: p_sql OUT NOCOPY VARCHAR2)
62: IS
63: BEGIN
64:

Line 74: ' pay_payroll_actions pa' ||

70: END IF;
71:
72: p_sql := ' select distinct p.person_id' ||
73: ' from per_people_f p,' ||
74: ' pay_payroll_actions pa' ||
75: ' where pa.payroll_action_id = :payroll_action_id' ||
76: ' and p.business_group_id = pa.business_group_id' ||
77: ' order by p.person_id';
78:

Line 98: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE)

94: --------------------------------------------------------------------
95: */
96:
97: PROCEDURE initialization_code
98: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE)
99: IS
100:
101: l_procedure VARCHAR2(80);
102:

Line 144: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,

140: --------------------------------------------------------------------
141: */
142:
143: PROCEDURE assignment_action_code
144: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
145: p_start_person_id IN per_all_people_f.person_id%TYPE,
146: p_end_person_id IN per_all_people_f.person_id%TYPE,
147: p_chunk IN NUMBER)
148: IS

Line 185: FROM pay_payroll_actions

181: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),NULL,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
182: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
183: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
184: ,pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters) assignment_set_id
185: FROM pay_payroll_actions
186: WHERE payroll_action_id = c_payroll_Action_id;
187:
188: CURSOR process_assignments_only(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
189: ,c_start_person_id IN per_all_people_f.person_id%TYPE

Line 188: CURSOR process_assignments_only(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE

184: ,pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters) assignment_set_id
185: FROM pay_payroll_actions
186: WHERE payroll_action_id = c_payroll_Action_id;
187:
188: CURSOR process_assignments_only(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
189: ,c_start_person_id IN per_all_people_f.person_id%TYPE
190: ,c_end_person_id IN per_all_people_f.person_id%TYPE
191: ,c_assignment_id IN per_all_assignments_f.assignment_id%TYPE
192: ,c_financial_year IN VARCHAR2

Line 198: ,pay_payroll_actions ppa

194: IS
195: SELECT DISTINCT paf.assignment_id
196: FROM per_assignments_f paf
197: ,per_people_f ppf
198: ,pay_payroll_actions ppa
199: WHERE ppa.payroll_action_id = c_payroll_action_id
200: AND ppf.person_id BETWEEN c_start_person_id AND c_end_person_id
201: AND ppf.person_id = paf.person_id
202: AND paf.assignment_id = c_assignment_id

Line 207: FROM pay_payroll_actions ppa1

203: AND paf.business_group_id = ppa.business_group_id
204: AND EXISTS
205: ( /* Check if a Datafile is run for this year */
206: SELECT '1'
207: FROM pay_payroll_actions ppa1
208: ,pay_assignment_actions paa1
209: WHERE ppa1.payroll_action_id = paa1.payroll_action_id
210: AND ppa1.report_type = 'AU_PS_DATA_FILE'
211: AND ppa1.report_qualifier = 'AU'

Line 220: FROM pay_payroll_actions ppa2

216: )
217: AND NOT EXISTS
218: ( /* Check if a locked Amended Payment Summary does not exist for this year */
219: SELECT '1'
220: FROM pay_payroll_actions ppa2
221: ,pay_assignment_actions paa2
222: ,pay_action_interlocks pai
223: WHERE ppa2.payroll_action_id = paa2.payroll_action_id
224: AND ppa2.report_type = 'AU_PAY_SUMM_AMEND'

Line 234: CURSOR process_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE

230: AND pai.locked_action_id = paa2.assignment_action_id
231: );
232:
233:
234: CURSOR process_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
235: ,c_start_person_id IN per_all_people_f.person_id%TYPE
236: ,c_end_person_id IN per_all_people_f.person_id%TYPE
237: ,c_assignment_set_id IN NUMBER
238: ,c_financial_year IN VARCHAR2

Line 244: ,pay_payroll_actions ppa

240: IS
241: SELECT DISTINCT paf.assignment_id
242: FROM per_assignments_f paf
243: ,per_people_f ppf
244: ,pay_payroll_actions ppa
245: ,hr_assignment_set_amendments has
246: WHERE ppa.payroll_action_id = c_payroll_action_id
247: AND ppf.person_id BETWEEN c_start_person_id AND c_end_person_id
248: AND ppf.person_id = paf.person_id

Line 256: FROM pay_payroll_actions ppa1

252: AND paf.business_group_id = ppa.business_group_id
253: AND EXISTS
254: ( /* Check if a Datafile is run for this year */
255: SELECT '1'
256: FROM pay_payroll_actions ppa1
257: ,pay_assignment_actions paa1
258: WHERE ppa1.payroll_action_id = paa1.payroll_action_id
259: AND ppa1.report_type = 'AU_PS_DATA_FILE'
260: AND ppa1.report_qualifier = 'AU'

Line 269: FROM pay_payroll_actions ppa2

265: )
266: AND NOT EXISTS
267: ( /* Check if a locked Amended Payment Summary does not exist for this year */
268: SELECT '1'
269: FROM pay_payroll_actions ppa2
270: ,pay_assignment_actions paa2
271: ,pay_action_interlocks pai
272: WHERE ppa2.payroll_action_id = paa2.payroll_action_id
273: AND ppa2.report_type = 'AU_PAY_SUMM_AMEND'

Line 1461: ,pay_payroll_actions mppa

1457: )
1458: IS
1459: SELECT selfplock.locked_action_id
1460: FROM pay_assignment_actions mpaa
1461: ,pay_payroll_actions mppa
1462: ,pay_action_interlocks mplock
1463: ,pay_action_interlocks selfplock
1464: WHERE mpaa.assignment_id = c_assignmenr_id
1465: AND mpaa.payroll_action_id = mppa.payroll_action_id

Line 1486: , pay_payroll_actions ppa

1482: , to_date('30-06-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),'DD-MM-YYYY')
1483: , pay_core_utils.get_parameter('LST_YR_TERM',ppa.legislative_parameters)
1484: , pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters)
1485: FROM pay_assignment_actions paa
1486: , pay_payroll_actions ppa
1487: WHERE paa.assignment_action_id = c_assignment_action_id
1488: AND ppa.payroll_action_id = paa.payroll_action_id ;
1489:
1490: CURSOR get_context_id(c_context_name ff_contexts.context_name%TYPE)

Line 1515: l_business_group_id pay_payroll_actions.business_group_id%TYPE ;

1511: ,'X_ETP3_PAYMENT_SUMMARY_TYPE'
1512: ,'X_ETP4_PAYMENT_SUMMARY_TYPE');
1513:
1514: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
1515: l_business_group_id pay_payroll_actions.business_group_id%TYPE ;
1516: l_registered_employer hr_organization_units.organization_id%TYPE;
1517: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;
1518: l_year_start pay_payroll_Actions.effective_date%TYPE;
1519: l_year_end pay_payroll_actions.effective_date%TYPE;

Line 1517: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;

1513:
1514: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
1515: l_business_group_id pay_payroll_actions.business_group_id%TYPE ;
1516: l_registered_employer hr_organization_units.organization_id%TYPE;
1517: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;
1518: l_year_start pay_payroll_Actions.effective_date%TYPE;
1519: l_year_end pay_payroll_actions.effective_date%TYPE;
1520: l_employee_type per_all_people_f.current_Employee_Flag%TYPE;
1521: l_lst_yr_term varchar2(10);

Line 1518: l_year_start pay_payroll_Actions.effective_date%TYPE;

1514: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
1515: l_business_group_id pay_payroll_actions.business_group_id%TYPE ;
1516: l_registered_employer hr_organization_units.organization_id%TYPE;
1517: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;
1518: l_year_start pay_payroll_Actions.effective_date%TYPE;
1519: l_year_end pay_payroll_actions.effective_date%TYPE;
1520: l_employee_type per_all_people_f.current_Employee_Flag%TYPE;
1521: l_lst_yr_term varchar2(10);
1522: l_fin_year VARCHAR2(20);

Line 1519: l_year_end pay_payroll_actions.effective_date%TYPE;

1515: l_business_group_id pay_payroll_actions.business_group_id%TYPE ;
1516: l_registered_employer hr_organization_units.organization_id%TYPE;
1517: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;
1518: l_year_start pay_payroll_Actions.effective_date%TYPE;
1519: l_year_end pay_payroll_actions.effective_date%TYPE;
1520: l_employee_type per_all_people_f.current_Employee_Flag%TYPE;
1521: l_lst_yr_term varchar2(10);
1522: l_fin_year VARCHAR2(20);
1523: l_archive_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 1705: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE)

1701:
1702: END modify_and_archive_code;
1703:
1704: PROCEDURE spawn_data_file
1705: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE)
1706: IS
1707:
1708: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
1709: l_business_group_id NUMBER;

Line 1708: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

1704: PROCEDURE spawn_data_file
1705: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE)
1706: IS
1707:
1708: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
1709: l_business_group_id NUMBER;
1710: l_start_date DATE;
1711: l_end_date DATE;
1712: l_effective_date DATE;

Line 1726: CURSOR csr_magtape_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

1722: -- Description : Fetches User Parameters from Legislative_paramters
1723: -- column.
1724: --------------------------------------------------------------------+
1725:
1726: CURSOR csr_magtape_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
1727: IS
1728: SELECT pay_core_utils.get_parameter('TEST_EFILE',legislative_parameters) TEST_EFILE,
1729: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID,
1730: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,

Line 1735: FROM pay_payroll_actions ppa

1731: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
1732: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,
1733: to_date(pay_core_utils.get_parameter('END_DATE',legislative_parameters),'YYYY/MM/DD') end_date,
1734: to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE',legislative_parameters),'YYYY/MM/DD') EFFECTIVE_DATE
1735: FROM pay_payroll_actions ppa
1736: WHERE ppa.payroll_action_id = c_payroll_action_id;
1737:
1738:
1739: CURSOR csr_lookup_code (c_financial_year VARCHAR2)