APPS.PAY_PAYWSQEE_PKG dependencies on PAY_BATCH_HEADERS

Line 590: v_batch_status pay_batch_headers.batch_status%TYPE := null;

586: p_act_parameter_group_id number default null) return number is
587: --
588: v_request_id number := 0;
589: v_pac_id pay_payroll_actions.payroll_action_id%TYPE;
590: v_batch_status pay_batch_headers.batch_status%TYPE := null;
591: --
592: l_wait_outcome BOOLEAN;
593: l_phase VARCHAR2(80);
594: l_status VARCHAR2(80);

Line 839: from pay_batch_headers

835: from pay_batch_lines
836: where batch_id = p_batch_id
837: union
838: select batch_status
839: from pay_batch_headers
840: where batch_id = p_batch_id
841: union
842: select 'Y'
843: from pay_batch_headers bth

Line 843: from pay_batch_headers bth

839: from pay_batch_headers
840: where batch_id = p_batch_id
841: union
842: select 'Y'
843: from pay_batch_headers bth
844: where bth.batch_id = p_batch_id
845: and bth.batch_status = 'T'
846: -- and not exists
847: -- (select null

Line 1003: from pay_batch_headers

999: p_batch_id number) is
1000: --
1001: cursor csr_name is
1002: select 1
1003: from pay_batch_headers
1004: where (batch_id <> p_batch_id or p_batch_id is null)
1005: and business_group_id = p_business_group_id
1006: and upper (batch_name) = upper (p_batch_name);
1007: --

Line 1268: from pay_batch_headers bth

1264: , inv.name;
1265: --
1266: cursor csr_bg_id is
1267: select bth.business_group_id
1268: from pay_batch_headers bth
1269: where bth.batch_id = p_batch_id;
1270: --
1271: l_business_group_id pay_batch_headers.business_group_id%TYPE;
1272: begin

Line 1271: l_business_group_id pay_batch_headers.business_group_id%TYPE;

1267: select bth.business_group_id
1268: from pay_batch_headers bth
1269: where bth.batch_id = p_batch_id;
1270: --
1271: l_business_group_id pay_batch_headers.business_group_id%TYPE;
1272: begin
1273: --
1274: begin
1275: --