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_ASSIGNMENT_ACTIONS

Line 150: v_next_action_id pay_assignment_actions.assignment_action_id%type;

146: p_end_person_id IN per_all_people_f.person_id%TYPE,
147: p_chunk IN NUMBER)
148: IS
149:
150: v_next_action_id pay_assignment_actions.assignment_action_id%type;
151:
152: v_lst_year_start date ;
153: v_fbt_year_start date ;
154: v_lst_fbt_year_start date ;

Line 193: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_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
193: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
194: IS
195: SELECT DISTINCT paf.assignment_id
196: FROM per_assignments_f paf
197: ,per_people_f ppf

Line 208: ,pay_assignment_actions paa1

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'
212: AND ppa1.report_category = 'REPORT'

Line 221: ,pay_assignment_actions paa2

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'
225: AND ppa2.report_qualifier = 'AU'

Line 239: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_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
239: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
240: IS
241: SELECT DISTINCT paf.assignment_id
242: FROM per_assignments_f paf
243: ,per_people_f ppf

Line 257: ,pay_assignment_actions paa1

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'
261: AND ppa1.report_category = 'REPORT'

Line 270: ,pay_assignment_actions paa2

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'
274: AND ppa2.report_qualifier = 'AU'

Line 284: SELECT pay_assignment_actions_s.nextval

280: );
281:
282: CURSOR next_action_id
283: IS
284: SELECT pay_assignment_actions_s.nextval
285: FROM dual;
286:
287: BEGIN
288:

Line 736: (p_archive_action_id IN pay_assignment_actions.assignment_action_id%TYPE

732: --------------------------------------------------------------------
733: */
734:
735: PROCEDURE find_new_missing_items
736: (p_archive_action_id IN pay_assignment_actions.assignment_action_id%TYPE
737: ,p_old_count IN NUMBER
738: ,p_all_tab_new IN archive_db_tab
739: ,p_new_count IN NUMBER)
740: IS

Line 743: (c_archive_action_id pay_assignment_actions.assignment_action_id%TYPE)

739: ,p_new_count IN NUMBER)
740: IS
741:
742: CURSOR get_archived_user_entities
743: (c_archive_action_id pay_assignment_actions.assignment_action_id%TYPE)
744: IS
745: SELECT fue.user_entity_name
746: FROM ff_archive_items fae,
747: ff_user_entities fue

Line 885: (p_archive_action_id IN pay_assignment_actions.assignment_action_id%TYPE

881: --------------------------------------------------------------------
882: */
883:
884: PROCEDURE slot_items_build_archive_list
885: (p_archive_action_id IN pay_assignment_actions.assignment_action_id%TYPE
886: ,p_all_tab_new IN archive_db_tab)
887: IS
888:
889: CURSOR csr_get_value(c_user_entity_name VARCHAR2,

Line 890: c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

886: ,p_all_tab_new IN archive_db_tab)
887: IS
888:
889: CURSOR csr_get_value(c_user_entity_name VARCHAR2,
890: c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
891: IS
892: SELECT fai.value
893: ,fdi.data_type
894: FROM ff_archive_items fai,

Line 1355: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE

1351: --------------------------------------------------------------------
1352: */
1353:
1354: PROCEDURE archive_db_items_tab(
1355: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
1356: ,p_db_item_tab IN archive_db_tab
1357: )
1358: IS
1359:

Line 1446: (p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE

1442: flags.
1443: --------------------------------------------------------------------
1444: */
1445: PROCEDURE modify_and_archive_code
1446: (p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
1447: ,p_effective_date IN DATE
1448: ,p_all_tab_new IN archive_db_tab)
1449: IS
1450:

Line 1454: (c_assignmenr_id pay_assignment_actions.assignment_id%TYPE

1450:
1451: l_procedure VARCHAR2(80);
1452:
1453: CURSOR get_orig_archive_id
1454: (c_assignmenr_id pay_assignment_actions.assignment_id%TYPE
1455: ,c_fin_year VARCHAR2
1456: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE
1457: )
1458: IS

Line 1456: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE

1452:
1453: CURSOR get_orig_archive_id
1454: (c_assignmenr_id pay_assignment_actions.assignment_id%TYPE
1455: ,c_fin_year VARCHAR2
1456: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE
1457: )
1458: IS
1459: SELECT selfplock.locked_action_id
1460: FROM pay_assignment_actions mpaa

Line 1460: FROM pay_assignment_actions mpaa

1456: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE
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

Line 1485: FROM pay_assignment_actions paa

1481: , to_date('01-07-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4),'DD-MM-YYYY')
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:

Line 1496: CURSOR get_archive_item_count(c_archive_action_id pay_assignment_actions.assignment_action_id%TYPE

1492: SELECT fc.context_id
1493: FROM ff_contexts fc
1494: WHERE fc.context_name = c_context_name;
1495:
1496: CURSOR get_archive_item_count(c_archive_action_id pay_assignment_actions.assignment_action_id%TYPE
1497: ,c_context_id ff_contexts.context_id%TYPE)
1498: IS
1499: SELECT COUNT(*)
1500: FROM ff_archive_items fai,

Line 1514: l_assignment_id pay_assignment_actions.assignment_id%TYPE;

1510: ,'X_ETP2_PAYMENT_SUMMARY_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;

Line 1523: l_archive_action_id pay_assignment_actions.assignment_action_id%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;
1524:
1525: l_eit_value VARCHAR2(10);
1526:
1527: l_new_count NUMBER;