APPS.PAY_USER_COLUMN_INSTA_MATRIX dependencies on HR_API

Line 140: and (legislation_code is null or legislation_code = hr_api.return_legislation_code(c_business_group_id));

136: select user_table_id
137: from pay_user_tables
138: where user_table_name = c_user_table_name
139: and (business_group_id is null or business_group_id = c_business_group_id)
140: and (legislation_code is null or legislation_code = hr_api.return_legislation_code(c_business_group_id));
141:
142:
143: cursor csr_get_user_column_id( c_user_column_name varchar2,c_user_table_id number)
144: is

Line 329: and (put.legislation_code is null or put.legislation_code = hr_api.return_legislation_code(:3))

325:
326:
327: l_statement := 'select 1 from pay_user_rows_f pur,pay_user_tables put where row_low_range_or_name = :1 and
328: (put.business_group_id is null or put.business_group_id = :2)
329: and (put.legislation_code is null or put.legislation_code = hr_api.return_legislation_code(:3))
330: and put.user_table_id = pur.user_table_id and
331: put.user_table_name = :4';
332:
333: open csr_ref_user_key for l_statement using p_row_low_range_or_name,l_business_group_id,l_business_group_id,p_user_table_name;

Line 362: and (put.legislation_code is null or put.legislation_code = hr_api.return_legislation_code(:5))

358: from pay_user_columns puc,pay_user_tables put
359: where put.user_table_name= :3
360: and puc.user_table_id=put.user_table_id
361: and (put.business_group_id is null or put.business_group_id = :4)
362: and (put.legislation_code is null or put.legislation_code = hr_api.return_legislation_code(:5))
363: Union
364: select ''TEMP'' qualifier,p_user_column_user_key
365: from hrdpv_create_user_column
366: where p_user_table_user_key= ''PAY_USER_TABLE:'' || :6 ||''#'' || :7 and

Line 658: and (put.legislation_code is null or put.legislation_code= hr_api.return_legislation_code(pbg.business_group_id))

654: from pay_user_columns puc,
655: per_business_groups pbg,
656: pay_user_tables put
657: where (put.business_group_id is null or put.business_group_id = pbg.business_group_id)
658: and (put.legislation_code is null or put.legislation_code= hr_api.return_legislation_code(pbg.business_group_id))
659: and pbg.name = c_business_group
660: and puc.user_column_name = c_user_column_name
661: and puc.user_table_id = put.user_table_id
662: and put.user_table_name = c_user_table_name

Line 735: and (put.legislation_code is null or put.legislation_code = hr_api.return_legislation_code(pbg.business_group_id))

731: from pay_user_rows_f pur,
732: per_business_groups pbg,
733: pay_user_tables put
734: where (put.business_group_id is null or put.business_group_id= pbg.business_group_id)
735: and (put.legislation_code is null or put.legislation_code = hr_api.return_legislation_code(pbg.business_group_id))
736: and pbg.name = c_business_group
737: and c_effective_date between pur.effective_start_date and pur.effective_end_date
738: and pur.row_low_range_or_name = c_user_row_name
739: and pur.user_table_id = put.user_table_id

Line 814: and (put.legislation_code is null or put.legislation_code= hr_api.return_legislation_code(pbg.business_group_id));

810: from pay_user_tables put,per_business_groups pbg
811: where user_table_name = c_user_table_name
812: and pbg.name = c_business_group
813: and (put.business_group_id is null or put.business_group_id = pbg.business_group_id)
814: and (put.legislation_code is null or put.legislation_code= hr_api.return_legislation_code(pbg.business_group_id));
815:
816: cursor csr_check_user_key_exists(c_unique_key_id number)
817: is
818: select user_key_id

Line 894: and (legislation_code is null or legislation_code = hr_api.return_legislation_code(c_business_group_id))

890: is
891: select user_table_id
892: from pay_user_tables
893: where (business_group_id is null or business_group_id = c_business_group_id )
894: and (legislation_code is null or legislation_code = hr_api.return_legislation_code(c_business_group_id))
895: and user_table_name = c_user_table_name;
896:
897: cursor csr_get_business_group_name(c_business_group_id number)
898: is