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_PAYROLL_ACTIONS

Line 110: FROM pay_payroll_actions

106: INSTR(legislative_parameters||' ',' ',
107: INSTR(legislative_parameters||' ',p_token||'='))
108: - (INSTR(legislative_parameters||' ',p_token||'=')+LENGTH(p_token||'='))),
109: business_group_id
110: FROM pay_payroll_actions
111: WHERE payroll_action_id = p_pact_id;
112:
113: l_business_group_id VARCHAR2(20);
114: l_token_value VARCHAR2(50);

Line 180: ,pay_payroll_actions ppa

176: CURSOR csr_arch_ref_no
177: IS
178: SELECT 1
179: FROM pay_action_information pai
180: ,pay_payroll_actions ppa
181: WHERE pai.action_information_category = 'IN_PF_BUSINESS_NUMBER'
182: AND pai.action_context_type = 'PA'
183: AND pai.action_information2 = g_arc_ref_no
184: AND pai.action_context_id = ppa.payroll_action_id

Line 824: FROM pay_payroll_actions

820: FETCH csr_reg_company INTO l_reg_comp_name ;
821: CLOSE csr_reg_company ;
822:
823: SELECT business_group_id INTO l_bus_group_id --Business Group Id
824: FROM pay_payroll_actions
825: WHERE payroll_action_id =p_arc_pay_action_id;
826:
827: pay_in_utils.set_location(g_debug,'Business Number : '||p_business_number,15);
828:

Line 1346: pay_payroll_actions ppa_init,

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
1350: AND ppa_init.action_type IN ('P','U','I')

Line 1382: pay_payroll_actions ppa_init,

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
1386: AND ppa_init.action_type IN ('P','U','I')

Line 1410: ,pay_payroll_actions ppa

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
1412: AND paa.assignment_action_id = pai.action_context_id
1413: AND ppa.payroll_action_id = paa.payroll_action_id
1414: AND ppa.report_type = 'IN_PF_ARCHIVE'

Line 1429: pay_payroll_actions ppa_init,

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
1432: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id
1433: AND paf.period_of_service_id = pps.period_of_service_id

Line 1460: ,pay_payroll_actions ppa

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
1461: WHERE paa.assignment_id = paa_init.assignment_id
1462: AND paa.assignment_action_id = pai.action_context_id
1463: AND ppa.payroll_action_id = paa.payroll_action_id
1464: AND hoi.organization_id = hou.organization_id

Line 1488: pay_payroll_actions ppa_init,

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
1492: AND ppa_init.action_type IN ('P','U','I')

Line 1531: pay_payroll_Actions ppa

1527: AND hoi_challan.org_information1 = g_challan_year
1528: AND hoi_challan.org_information2 = g_challan_mth
1529: AND NOT EXISTS (SELECT pai.action_information8
1530: FROM pay_action_information pai,
1531: pay_payroll_Actions ppa
1532: WHERE pai.action_information8 = hoi_challan.org_information12
1533: AND pai.action_information_category = 'IN_PF_CHALLAN'
1534: AND pai.action_context_type = 'PA'
1535: AND pai.action_information3 = p_pf_org

Line 1600: pay_payroll_Actions ppa

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'
1604: AND action_information1 = nvl(p_business_no,action_information1)

Line 1910: ,pay_payroll_actions ppa

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
1914: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1924: pay_payroll_actions ppa1

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
1928: AND paa1.assignment_id = p_assignment_id