APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 2925: ,pay_action_interlocks pal

2921: --
2922: CURSOR csr_get_pactid IS
2923: SELECT DISTINCT paa1.payroll_action_id
2924: FROM pay_assignment_actions paa
2925: ,pay_action_interlocks pal
2926: ,pay_assignment_actions paa1
2927: WHERE paa.payroll_action_id = p_actid
2928: AND paa.assignment_action_id = pal.locking_action_id
2929: AND pal.locked_action_id = paa1.assignment_action_id

Line 2962: ,pay_action_interlocks ai

2958: AND pai.action_context_id = ppa.payroll_action_id
2959: AND pai.action_information_category = 'NL_WR_SWMF_SECTOR_RISK_GROUP'
2960: AND EXISTS ( SELECT 1
2961: FROM pay_assignment_actions paa1
2962: ,pay_action_interlocks ai
2963: ,pay_assignment_actions paa2
2964: WHERE paa1.payroll_action_id = p_actid
2965: AND paa1.assignment_action_id = ai.locking_action_id
2966: AND ai.locked_action_id = paa2.assignment_action_id

Line 2974: ,pay_action_interlocks pai

2970: CURSOR csr_payroll_get_action_id(c_payroll_action_id NUMBER) IS
2971: SELECT max(locked_action_id)
2972: FROM pay_assignment_actions paa
2973: ,pay_payroll_actions ppa
2974: ,pay_action_interlocks pai
2975: WHERE ppa.payroll_action_id = c_payroll_action_id
2976: AND paa.payroll_action_id = ppa.payroll_action_id
2977: AND pai.locking_action_id = paa.assignment_action_id;
2978: --

Line 2985: ,pay_action_interlocks pai

2981: ,c_end_date DATE) IS
2982: SELECT max(paa2.assignment_action_id)
2983: FROM pay_assignment_actions paa
2984: ,pay_payroll_actions ppa
2985: ,pay_action_interlocks pai
2986: ,pay_assignment_actions paa1
2987: ,pay_assignment_actions paa2
2988: ,pay_payroll_actions ppa2
2989: WHERE ppa.payroll_action_id = c_payroll_action_id

Line 5996: ,pay_action_interlocks pai

5992: FROM DUAL
5993: WHERE EXISTS(SELECT /*+ ORDERED */ 1
5994: FROM pay_assignment_actions paa
5995: ,pay_payroll_actions ppa
5996: ,pay_action_interlocks pai
5997: ,pay_assignment_actions pal
5998: ,pay_payroll_actions ppl
5999: WHERE paa.assignment_id = c_assignment_id
6000: AND paa.payroll_action_id = ppa.payroll_action_id

Line 7907: FROM pay_action_interlocks pal

7903: CURSOR csr_action_info(c_category VARCHAR2
7904: ,c_type VARCHAR2
7905: ,c_assignment_id NUMBER) IS
7906: SELECT pai.*
7907: FROM pay_action_interlocks pal
7908: ,pay_action_information pai
7909: WHERE pal.locking_action_id = p_assactid
7910: AND pal.locked_action_id = pai.action_context_id
7911: AND pai.action_context_type = 'AAP'

Line 7920: FROM pay_action_interlocks pal

7916: --
7917: CURSOR csr_get_income_start_date(c_assactid NUMBER
7918: ,c_assignment_id NUMBER) IS
7919: SELECT MIN(fnd_date.canonical_to_date(action_information5))
7920: FROM pay_action_interlocks pal
7921: ,pay_action_information pai
7922: WHERE pal.locking_action_id = c_assactid
7923: AND pal.locked_action_id = pai.action_context_id
7924: AND pai.action_context_type = 'AAP'

Line 7934: FROM pay_action_interlocks pal

7930: ,c_assignment_id NUMBER
7931: ,c_sector VARCHAR2
7932: ,c_risk_grp VARCHAR2) IS
7933: SELECT MIN(fnd_date.canonical_to_date(action_information5))
7934: FROM pay_action_interlocks pal
7935: ,pay_action_information pai
7936: WHERE pal.locking_action_id = c_assactid
7937: AND pal.locked_action_id = pai.action_context_id
7938: AND pai.action_context_type = 'AAP'

Line 8003: from pay_action_interlocks pal

7999: ,sum(fnd_number.canonical_to_number(pai.action_information26)) sum26
8000: ,sum(fnd_number.canonical_to_number(pai.action_information27)) sum27
8001: ,sum(fnd_number.canonical_to_number(pai.action_information28)) sum28
8002: ,sum(fnd_number.canonical_to_number(pai.action_information29)) sum29
8003: from pay_action_interlocks pal
8004: ,pay_action_information pai
8005: where pal.locking_action_id = c_assactid
8006: AND pal.locked_action_id = pai.action_context_id
8007: AND pai.action_context_type = 'AAP'