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

Line 688: ,pay_assignment_actions act

684: ,as1.payroll_id
685: FROM pay_payroll_actions ppa
686: ,pay_payroll_actions appa
687: ,pay_payroll_actions appa2
688: ,pay_assignment_actions act
689: ,pay_assignment_actions act1
690: ,pay_action_interlocks pai
691: ,per_all_assignments_f as1
692: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 689: ,pay_assignment_actions act1

685: FROM pay_payroll_actions ppa
686: ,pay_payroll_actions appa
687: ,pay_payroll_actions appa2
688: ,pay_assignment_actions act
689: ,pay_assignment_actions act1
690: ,pay_action_interlocks pai
691: ,per_all_assignments_f as1
692: WHERE ppa.payroll_action_id = p_payroll_action_id
693: AND appa.effective_date BETWEEN l_canonical_start_date

Line 872: SELECT pay_assignment_actions_s.NEXTVAL

868:
869: --Only Active Hourly(Annual Report)
870: OR (l_report_type = 'PYDKEHOLCA_ANN' and l_hourly_salaried ='H' and l_term_date > l_canonical_end_date)
871: THEN
872: SELECT pay_assignment_actions_s.NEXTVAL
873: INTO l_actid
874: FROM dual;
875:
876: -- Create the archive assignment action

Line 901: SELECT pay_assignment_actions_s.NEXTVAL

897: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id
898: --AND l_prev_person_id <> rec_prepaid_assignments.person_id
899: AND l_prev_assg_id <> rec_prepaid_assignments.assignment_id
900: THEN
901: SELECT pay_assignment_actions_s.NEXTVAL
902: INTO l_actid
903: FROM dual;
904:
905: -- Create the archive assignment action

Line 970: pay_assignment_actions pac,

966: pap.first_name||' '||pap.middle_names||' '||pap.last_name pname, pap.sex, pap.start_date, pap.business_group_id,
967: assign.hourly_salaried_code HOURLY_SALARIED_CODE, assign.assignment_number, assign.organization_id, assign.primary_flag,
968: assign.location_id
969: FROM
970: pay_assignment_actions pac,
971: per_all_assignments_f assign,
972: per_all_people_f pap
973: WHERE pac.assignment_action_id = p_asg_act_id
974: AND assign.assignment_id = pac.assignment_id

Line 1265: (select 1 from pay_payroll_actions ppa, pay_assignment_actions paa

1261: AND ptp.end_date BETWEEN c_canonical_start_date AND c_canonical_end_date
1262: AND ppf.business_group_id = g_business_group_id
1263: AND ptp.end_date between paf.effective_start_date and paf.effective_end_date
1264: and exists
1265: (select 1 from pay_payroll_actions ppa, pay_assignment_actions paa
1266: where ppa.payroll_action_id = paa.payroll_action_id
1267: and ppa.action_type IN ('R','Q')
1268: AND ppa.effective_date between c_canonical_start_date and c_canonical_end_date
1269: AND paa.assignment_id = paf.assignment_id

Line 1366: ,pay_assignment_actions pac

1362: ,p_end_date DATE
1363: ,p_business_group_id NUMBER) IS
1364: SELECT MAX( EFFECTIVE_END_DATE) EFFECTIVE_END_DATE
1365: FROM per_all_assignments_f paa
1366: ,pay_assignment_actions pac
1367: WHERE pac.assignment_action_id = p_asg_act_id
1368: AND paa.assignment_id = pac.assignment_id
1369: -- AND paa.EFFECTIVE_START_DATE <= p_end_date 10322958
1370: AND paa.EFFECTIVE_END_DATE > = p_start_date

Line 1394: from pay_assignment_actions pac, pay_payroll_actions ppa

1390: lr_Get_Defined_Balance_Id csr_Get_Defined_Balance_Id%rowtype;
1391:
1392: CURSOR csr_asg_action_id(assg_id NUMBER, pid NUMBER, tid NUMBER, le_id NUMBER) IS
1393: select MAX(pac.ASSIGNMENT_ACTION_ID) id
1394: from pay_assignment_actions pac, pay_payroll_actions ppa
1395: where ppa.action_type IN ('R','Q')
1396: and pac.payroll_action_id = ppa.payroll_action_id
1397: and pac.assignment_id= assg_id
1398: and ppa.payroll_id=pid

Line 1424: ,pay_assignment_actions act

1420: SELECT 1
1421: FROM pay_payroll_actions ppa
1422: ,pay_payroll_actions appa
1423: ,pay_payroll_actions appa2
1424: ,pay_assignment_actions act
1425: ,pay_assignment_actions act1
1426: ,pay_action_interlocks pai
1427: ,per_all_assignments_f as1
1428:

Line 1425: ,pay_assignment_actions act1

1421: FROM pay_payroll_actions ppa
1422: ,pay_payroll_actions appa
1423: ,pay_payroll_actions appa2
1424: ,pay_assignment_actions act
1425: ,pay_assignment_actions act1
1426: ,pay_action_interlocks pai
1427: ,per_all_assignments_f as1
1428:
1429: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 1467: FROM pay_assignment_actions paa,

1463: AND p_date_earned BETWEEN ppf.EFFECTIVE_START_DATE AND ppf.EFFECTIVE_END_DATE;
1464:
1465: CURSOR cur_max_asg_act_id(p_assignment_id NUMBER, p_start_date DATE, p_end_date DATE) IS
1466: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id
1467: FROM pay_assignment_actions paa,
1468: pay_payroll_actions ppa
1469: WHERE ppa.payroll_action_id = paa.payroll_action_id
1470: and paa.assignment_id = p_assignment_id
1471: and ppa.action_type in ('R','Q','I','B','V')

Line 1830: FROM pay_assignment_actions

1826: BEGIN
1827:
1828: SELECT payroll_action_id, assignment_id
1829: INTO l_payroll_action_id,l_ass_id /* 9489806 */
1830: FROM pay_assignment_actions
1831: WHERE assignment_action_id=p_assignment_action_id;
1832: END;
1833:
1834: IF g_debug THEN

Line 1924: (select 1 from pay_payroll_actions ppa, pay_assignment_actions paa

1920: ptp.start_date and ptp.end_date)'
1921: ||' AND ppf.business_group_id = ' || g_business_group_id ||
1922: ' AND (ptp.end_date between paf.effective_start_date and paf.effective_end_date OR ptp.start_date between paf.effective_start_date and paf.effective_end_date )
1923: and exists
1924: (select 1 from pay_payroll_actions ppa, pay_assignment_actions paa
1925: where ppa.payroll_action_id = paa.payroll_action_id
1926: and ppa.action_type IN ('||''''||'R'||''''||','||''''||'Q'||''''|| ') '
1927: ||' AND ppa.effective_date between '||''''|| l_canonical_start_date ||''''||' and ' ||''''|| l_canonical_end_date ||''''
1928: ||' AND paa.assignment_id = paf.assignment_id

Line 1937: pay_assignment_actions paa

1933:
1934: l_select_qry := l_select_str
1935: ||' FROM
1936: pay_payroll_actions ppa,
1937: pay_assignment_actions paa
1938: where ppa.payroll_action_id = paa.payroll_action_id
1939: and ppa.action_type IN ('||''''||'R'||''''||','||''''||'Q'||''''|| ') '
1940: ||' AND ppa.effective_date between '||''''|| l_canonical_start_date ||''''||' and ' ||''''|| l_canonical_end_date ||''''
1941: || l_where_clause

Line 3283: PAY_ASSIGNMENT_ACTIONS PAA,

3279:
3280: CURSOR cur_all_payrolls(p_payroll_action_id IN NUMBER, p_report_type VARCHAR2) IS
3281: SELECT distinct PAI.ACTION_INFORMATION30 Payroll_id
3282: FROM
3283: PAY_ASSIGNMENT_ACTIONS PAA,
3284: PAY_ACTION_INFORMATION PAI
3285: WHERE
3286: PAA.PAYROLL_ACTION_ID = p_payroll_action_id
3287: AND PAI.ACTION_CONTEXT_ID = PAA.ASSIGNMENT_ACTION_ID

Line 3298: PAY_ASSIGNMENT_ACTIONS PAA,

3294: ,p_report_type VARCHAR2)
3295: IS
3296: SELECT PAI.*
3297: FROM
3298: PAY_ASSIGNMENT_ACTIONS PAA,
3299: PAY_ACTION_INFORMATION PAI
3300: WHERE
3301: PAA.PAYROLL_ACTION_ID = p_payroll_action_id
3302: AND PAI.ACTION_CONTEXT_ID = PAA.ASSIGNMENT_ACTION_ID

Line 3318: PAY_ASSIGNMENT_ACTIONS PAA,

3314: p_hcard_info VARCHAR2,
3315: p_report_type VARCHAR2) IS
3316: SELECT PAI.*
3317: FROM
3318: PAY_ASSIGNMENT_ACTIONS PAA,
3319: PAY_ACTION_INFORMATION PAI
3320: WHERE
3321: PAA.PAYROLL_ACTION_ID = p_payroll_action_id
3322: AND PAI.ACTION_CONTEXT_ID = PAA.ASSIGNMENT_ACTION_ID

Line 3341: PAY_ASSIGNMENT_ACTIONS PAA,

3337: p_year PAY_ACTION_INFORMATION.ACTION_INFORMATION6%TYPE,
3338: p_report_type VARCHAR2) IS
3339: SELECT PAI.*
3340: FROM
3341: PAY_ASSIGNMENT_ACTIONS PAA,
3342: PAY_ACTION_INFORMATION PAI
3343: WHERE
3344: PAA.PAYROLL_ACTION_ID = p_payroll_action_id
3345: AND PAI.ACTION_CONTEXT_ID = PAA.ASSIGNMENT_ACTION_ID

Line 3379: PAY_ASSIGNMENT_ACTIONS PAA,

3375: ,p_period_id PAY_ACTION_INFORMATION.ACTION_INFORMATION29%TYPE)
3376: IS
3377: SELECT PAI.*
3378: FROM
3379: PAY_ASSIGNMENT_ACTIONS PAA,
3380: PAY_ACTION_INFORMATION PAI
3381: WHERE
3382: PAA.PAYROLL_ACTION_ID = p_payroll_action_id
3383: AND PAI.ACTION_CONTEXT_ID = PAA.ASSIGNMENT_ACTION_ID

Line 3402: PAY_ASSIGNMENT_ACTIONS PAA,

3398: p_period_id PAY_ACTION_INFORMATION.ACTION_INFORMATION28%TYPE,
3399: p_hcard_info PAY_ACTION_INFORMATION.ACTION_INFORMATION3%TYPE) IS
3400: SELECT PAI.*
3401: FROM
3402: PAY_ASSIGNMENT_ACTIONS PAA,
3403: PAY_ACTION_INFORMATION PAI
3404: WHERE
3405: PAA.PAYROLL_ACTION_ID = p_payroll_action_id
3406: AND PAI.ACTION_CONTEXT_ID = PAA.ASSIGNMENT_ACTION_ID