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

Line 533: pay_assignment_actions paa

529: FROM pay_run_results prr,
530: pay_run_result_values prv,
531: pay_element_types_f pet,
532: pay_input_values_f piv,
533: pay_assignment_actions paa
534: WHERE prr.run_result_id = prv.run_result_id
535: AND prr.element_type_id = pet.element_type_id
536: AND pet.element_type_id = piv.element_type_id
537: AND piv.input_value_id = prv.input_value_id

Line 1345: FROM pay_assignment_actions paa_init,

1341:
1342: CURSOR csr_process_assignments
1343: IS
1344: SELECT DISTINCT paa_init.assignment_id
1345: FROM pay_assignment_actions paa_init,
1346: pay_payroll_actions ppa_init,
1347: per_assignments_f paf,
1348: hr_organization_information hoi
1349: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id

Line 1381: FROM pay_assignment_actions paa_init,

1377:
1378: CURSOR csr_process_supp_assignments(p_business_no VARCHAR2 )
1379: IS
1380: SELECT DISTINCT paa_init.assignment_id
1381: FROM pay_assignment_actions paa_init,
1382: pay_payroll_actions ppa_init,
1383: per_assignments_f paf,
1384: hr_organization_information hoi
1385: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id

Line 1407: FROM pay_assignment_actions paa

1403: FROM hr_soft_coding_keyflex scl
1404: WHERE scl.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
1405: AND scl.enabled_flag = 'Y')
1406: AND NOT EXISTS ( SELECT paa.assignment_id
1407: FROM pay_assignment_actions paa
1408: ,pay_action_information pai
1409: ,hr_organization_information hoi
1410: ,pay_payroll_actions ppa
1411: WHERE paa.assignment_id = paa_init.assignment_id

Line 1427: FROM pay_assignment_actions paa_init,

1423: AND hoi.org_information2 = g_challan_mth
1424: )
1425: UNION
1426: SELECT DISTINCT paa_init.assignment_id
1427: FROM pay_assignment_actions paa_init,
1428: per_periods_of_service pps,
1429: pay_payroll_actions ppa_init,
1430: per_assignments_f paf,
1431: hr_organization_information hoi

Line 1456: FROM pay_assignment_actions paa

1452: FROM hr_soft_coding_keyflex scl
1453: WHERE scl.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
1454: AND scl.enabled_flag = 'Y')
1455: AND NOT EXISTS ( SELECT paa.assignment_id
1456: FROM pay_assignment_actions paa
1457: ,pay_action_information pai
1458: ,hr_organization_information hoi
1459: ,hr_organization_units hou
1460: ,pay_payroll_actions ppa

Line 1487: FROM pay_assignment_actions paa_init,

1483:
1484: CURSOR csr_process_rev_assignments(p_business_no VARCHAR2)
1485: IS
1486: SELECT DISTINCT paa_init.assignment_id
1487: FROM pay_assignment_actions paa_init,
1488: pay_payroll_actions ppa_init,
1489: per_assignments_f paf,
1490: hr_organization_information hoi
1491: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id

Line 1599: pay_assignment_actions paa,

1595: ,p_business_no IN NUMBER)
1596: IS
1597: SELECT DISTINCT action_context_id
1598: FROM pay_action_information pai,
1599: pay_assignment_actions paa,
1600: pay_payroll_Actions ppa
1601: WHERE action_information2 = p_arc_ref
1602: AND action_context_type = 'AAP'
1603: AND action_information_category = 'IN_PF_PERSON_DTLS'

Line 1690: SELECT pay_assignment_actions_s.NEXTVAL

1686:
1687: END LOOP ;
1688: FOR csr_rec IN csr_process_supp_assignments(rec_reg_return.bus_no)
1689: LOOP
1690: SELECT pay_assignment_actions_s.NEXTVAL
1691: INTO l_action_id
1692: FROM dual;
1693:
1694: IF g_debug THEN

Line 1763: SELECT pay_assignment_actions_s.NEXTVAL

1759: END LOOP ;
1760:
1761: FOR csr_rec IN csr_process_rev_assignments(rec_reg_return.bus_no)
1762: LOOP
1763: SELECT pay_assignment_actions_s.NEXTVAL
1764: INTO l_action_id
1765: FROM dual;
1766:
1767: IF g_debug THEN

Line 1813: SELECT pay_assignment_actions_s.NEXTVAL

1809: pay_in_utils.set_location(g_debug,'Entering: Regular',5);
1810: FOR csr_rec IN csr_process_assignments
1811: LOOP
1812:
1813: SELECT pay_assignment_actions_s.NEXTVAL
1814: INTO l_action_id
1815: FROM dual;
1816:
1817: IF g_debug THEN

Line 1897: FROM pay_assignment_actions paa

1893: IS
1894: SELECT paa.assignment_id
1895: ,paa.payroll_action_id
1896: ,paf.person_id
1897: FROM pay_assignment_actions paa
1898: ,per_assignments_f paf
1899: WHERE paa.assignment_action_id = p_assignment_action_id
1900: AND paa.assignment_id = paf.assignment_id
1901: AND ROWNUM =1;

Line 1909: FROM pay_assignment_actions paa

1905: ,p_end_date DATE
1906: ,p_assignment_id NUMBER)
1907: IS
1908: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) run_asg_action_id
1909: FROM pay_assignment_actions paa
1910: ,pay_payroll_actions ppa
1911: ,per_assignments_f paf
1912: WHERE paf.assignment_id = paa.assignment_id
1913: AND paf.assignment_id = p_assignment_id

Line 1923: pay_assignment_actions paa1,

1919: AND paa.source_action_id IS NULL
1920: AND (1 = DECODE(ppa.action_type,'I',1,0)
1921: OR EXISTS (SELECT ''
1922: FROM pay_action_interlocks intk,
1923: pay_assignment_actions paa1,
1924: pay_payroll_actions ppa1
1925: WHERE intk.locked_action_id = paa.assignment_Action_id
1926: AND intk.locking_action_id = paa1.assignment_action_id
1927: AND paa1.payroll_action_id =ppa1.payroll_action_id