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 537: pay_assignment_actions paa

533: FROM pay_run_results prr,
534: pay_run_result_values prv,
535: pay_element_types_f pet,
536: pay_input_values_f piv,
537: pay_assignment_actions paa
538: WHERE prr.run_result_id = prv.run_result_id
539: AND prr.element_type_id = pet.element_type_id
540: AND pet.element_type_id = piv.element_type_id
541: AND piv.input_value_id = prv.input_value_id

Line 1349: FROM pay_assignment_actions paa_init,

1345:
1346: CURSOR csr_process_assignments
1347: IS
1348: SELECT DISTINCT paa_init.assignment_id
1349: FROM pay_assignment_actions paa_init,
1350: pay_payroll_actions ppa_init,
1351: per_assignments_f paf,
1352: hr_organization_information hoi
1353: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id

Line 1385: FROM pay_assignment_actions paa_init,

1381:
1382: CURSOR csr_process_supp_assignments(p_business_no VARCHAR2 )
1383: IS
1384: SELECT DISTINCT paa_init.assignment_id
1385: FROM pay_assignment_actions paa_init,
1386: pay_payroll_actions ppa_init,
1387: per_assignments_f paf,
1388: hr_organization_information hoi
1389: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id

Line 1411: FROM pay_assignment_actions paa

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

Line 1431: FROM pay_assignment_actions paa_init,

1427: AND hoi.org_information2 = g_challan_mth
1428: )
1429: UNION
1430: SELECT DISTINCT paa_init.assignment_id
1431: FROM pay_assignment_actions paa_init,
1432: per_periods_of_service pps,
1433: pay_payroll_actions ppa_init,
1434: per_assignments_f paf,
1435: hr_organization_information hoi

Line 1460: FROM pay_assignment_actions paa

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

Line 1491: FROM pay_assignment_actions paa_init,

1487:
1488: CURSOR csr_process_rev_assignments(p_business_no VARCHAR2)
1489: IS
1490: SELECT DISTINCT paa_init.assignment_id
1491: FROM pay_assignment_actions paa_init,
1492: pay_payroll_actions ppa_init,
1493: per_assignments_f paf,
1494: hr_organization_information hoi
1495: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id

Line 1603: pay_assignment_actions paa,

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

Line 1694: SELECT pay_assignment_actions_s.NEXTVAL

1690:
1691: END LOOP ;
1692: FOR csr_rec IN csr_process_supp_assignments(rec_reg_return.bus_no)
1693: LOOP
1694: SELECT pay_assignment_actions_s.NEXTVAL
1695: INTO l_action_id
1696: FROM dual;
1697:
1698: IF g_debug THEN

Line 1767: SELECT pay_assignment_actions_s.NEXTVAL

1763: END LOOP ;
1764:
1765: FOR csr_rec IN csr_process_rev_assignments(rec_reg_return.bus_no)
1766: LOOP
1767: SELECT pay_assignment_actions_s.NEXTVAL
1768: INTO l_action_id
1769: FROM dual;
1770:
1771: IF g_debug THEN

Line 1817: SELECT pay_assignment_actions_s.NEXTVAL

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

Line 1901: FROM pay_assignment_actions paa

1897: IS
1898: SELECT paa.assignment_id
1899: ,paa.payroll_action_id
1900: ,paf.person_id
1901: FROM pay_assignment_actions paa
1902: ,per_assignments_f paf
1903: WHERE paa.assignment_action_id = p_assignment_action_id
1904: AND paa.assignment_id = paf.assignment_id
1905: AND ROWNUM =1;

Line 1913: FROM pay_assignment_actions paa

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

Line 1927: pay_assignment_actions paa1,

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